I thought this would be easy, but apparantly not (for me)
I have two tables
Stafftbl
StaffID
Name
Mon Hours
Tue Hours
Wed Hours
etc
Timecard
StaffID
MonHours
TuesHours
etc
The idea being that the staff table contains the standard hours a worker
works each week, so one record for each staff member.
The timecard table then is a record of the number of hours worked every week - which varies.
When I open the timecard form I would like to be able to select a staff
member from a combo box (lookup from staff table) and then populate the forum with the standard data from the stafftable, then make alterations to store the record. So for example I selct Mr Taylor. The form then pulls out the standard hours worked each day (say 8) I can then modify Monday's hours to 9, and Tuesdays to 7 then store the whole record
But i am completely baffled as to how to do this. I thought abut a combo box but that only finds the record based on the current table, not a different table
Any ideas?