Hello all, I am (obviously) a rookie to Access. Creating a database to store information about contract employees. Plan on splitting the database so everything will be run through forms (too many cooks to spoil the hard work).
Have four tables matching the four types of data we store:
tblInfo_ID - "main table" stores names, address, email etc.
tblCertDates - info on 3 certifications we require and dates tests taken
tblOverUnder - Over/Under as per follow-up reviews
tblQAScores - Customer Service Scores
All but the tblInfo_ID will have many entries for each employee
My problem as silly as it sounds is I need a header that is a search on a last, first name on multiple forms as the data is updated monthly and I plan on turning off the ability to move between records, so as not to allow editing of ANYTHING, only inputting new data.
Process works like this: Office support person searches on a person by name (they are stored in two separate fields, have querry that combines to last,first) and then either through tabs or separate forms is able to enter the new months data for that person. The ID for each employee is an autonumber.
I keep getting close but no cigar. I feel helpless. Thanks for any and all help.