I have been working on a data base for months now. It will serve the purpose of an HRIS. I am not trained in Access and have been "learning as I go". I am not a programmer and do not understand code but can duplicate what someone else does by watching video. I nearly have everything completed and close to being able to use my database.
I have made great progress with my database, but I am stuck.
I have a table “Personal Information” which contains the EmployeeID (not an auto number) which is the Primary Key for the table.
I have created a form to use for data entry into the table.
I have created multiple other forms based on other tables of information.
The foreign key for the other forms is EmployeeID. I have created the relationships.
The other forms have an EmployeeID field, Last Name field, and First Name field based off of the Personal Information table.
I have created navigational forms which group certain forms together.
I have a main form to access the different navigational forms.
Upon log in, it takes you to the Main Form. From there you can access 4 different navigational forms.
When entering a new hire, I select Personnel Navigation and the first form opens to a new record.
I would like to be able to enter the Employee ID and First and Last Name into the first form and it automatically populate all the other forms labels of the same type.
Can you help me with this? I’ve tried everything I know but I can’t get it to work.
Thank you-
At this point, if I could find someone to get onto a web conference call where I could share my screen (I have this tool), I would be willing to pay for help. I really need this database.