So it has been a while since I worked in Access so I am very rusty. Here is the scenario:
Employee table with your basic data - fname, lname, empid, payrate and some others
Time entry table that has several fields including empid and payrate.
In the time entry form I have a combo box that is populated by a query allowing you to choose the employee you will be entering time for.
My problem - When I choose the employee I want the payrate text box to auto-populate with the payrate from the employee table. That information will in turn be placed in the payrate field of the time entry table.
Before you ask - Yes the payrate will be included in both tables but I want to be able to record in the time entry table how much they were being paid at the time of the entry.
Thanks in advance for any help.