First off, I thank you for reading. I'm in way over my head (always say yes to the boss right?) and think if I can get this one item I can at least pass.....
Building a DB in Access 2010, that has multiple tables that are all for data collection on employees. The primary key for the "main" table was impossible. Could not use last name or last,first as several family members usually work at one of our affiliates, and it is possible that all the data we will ever have on people are their names and some test scores.
So I came up with using a combination of Last Name, followed by basically an autonumber. I had 3000 name I had to import so this worked well for the import but now we will be using forms from here on out. I notice on the form, as soon as any entry is made, the autonumber field populates correctly with the next number. So the question is (keeping in mind this is my first shot at Access) does a possibility exist of the "EmpID" field auto populating while the form is still active or as it is saved? The first field to fill out on the form is Last name, and as soon as that is complete we have everything needed for the ID (Smith3011 for example) just could not find a solution searching through here.
To summarize: I would like to take two fields and combine into one
Last name:
IDNumber:
And somehow on the form turn automatically into
EmpID:[LastName][IDNumber] without any spaces or punctuation.
Thank you VERY much for any help.!!