Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Dual ID's (2000/SR1)

    Our inventory control system is set up so that each user has 2 user ID's, (they could have more, thank goodness it's only 2). Each of our forklifts has a computer on it and when the driver logs in, they perform a safety check on the computer. I am setting up a seperate system for equipment maintenance and I want to keep track of each driver.

    Is there a way that I can set up an employee table, with two fields one for PrimaryID & the other for SecondaryID, tied to a maintenance table, so that if I put in either ID, it will pull up the employees name? (the other way to do it is to have seperate entries for each employee with only PrimaryID but then it becomes a maintenance issue, if employee information changes, you have to change both records.) I'm sure there is a way to do it, I just don't know how. If anybody can help, that would be great. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dual ID's (2000/SR1)

    Hi Don,

    You can't do this in a table, but it may be possible in a form based on the table(s). If I understand you correctly, you want the end-user to be able to enter either of the employee ID's in the same text box, and have the system figure out which employee is meant. whether this is possible, and how easy or difficult it is, depends on the sturcture of the ID's: is it easy to see what is a primary ID and what is a secondary ID?
    Also, would data entry be made easier if the end user could select an employee ID from a combo box?

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Dual ID's (2000/SR1)

    Hi Hans,

    Thanks for the quick response. Last question first, yes, I would like to have a combo box to enter the information.

    The ID's are set up as follows (I'll use my own as an example):
    Primary G, last 4 digits of Social Security Number, then initials of first and last name, example G2471DE
    Secondary XLA, then last 4 digits of SS#, example XLA2471

    That part is all set and I can't change it and yes we do need both sign ons. (the system only allows each UserID to be used on only one machine at a time and our forklift operators have to be on a computer on their forklift and a desktop at the same time.)

    Hope this is the information that you need. Thanks for your help.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dual ID's (2000/SR1)

    Couldn't you just use the last four digits of the social security number in the database? You could use an employee table to get the corresponding initials, and so construct the primary ID; the secondary ID is simple, just put "XLA" in front of the four digits.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Dual ID's (2000/SR1)

    The use of social security numbers as identifiers in data has gotten very touchy in the US. Government agencies aren't allowed to do it at all and even private employers are being very careful about where they expose any part of the SSN. In our own applications we allow the capture of an employee identifier, but it doesn't get displayed in any output.
    Charlotte

  6. #6
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Re: Dual ID's (2000/SR1)

    Hans,

    Thanks for your assistance. I can't use just the 4 digits, because, believe it or not, we have 55 people here and I have 2 different pairs that each have the same last 4 digits to their Social Security #. I know the odds aren't huge, since we are only talking about 9,999 numbers but still...

    I think that I may have to have a different employee ID for each employee (I think I'll just use an autonumber) and then have a table that allows me to put in any ID, tied to the employees ID. Thanks for your help.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dual ID's (2000/SR1)

    But if the last four digits aren't unique, the secondary ID ("XLA" followed by the last four digits) won't be unique either. So if a forklift operator enters his/her secondary ID, you won't be able to link this to a unique person <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •