create new record based on combo box selection

[haylau]

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?

[pbaldy]

This technique should work:

http://www.baldyweb.com/Autofill.htm

A combo box can get its selections from a different table than the one the form is based on. It's probably the most common scenario in fact. By the way, personally I would name the fields differently. You will run into situations where you see MonHours and you won't know which it is. I'd name the standard fields MonHoursSched or something like that, to differentiate them.

[haylau]

This technique should work:

http://www.baldyweb.com/Autofill.htm

A combo box can get its selections from a different table than the one the form is based on. It's probably the most common scenario in fact. By the way, personally I would name the fields differently. You will run into situations where you see MonHours and you won't know which it is. I'd name the standard fields MonHoursSched or something like that, to differentiate them.

Many thanks Paul , exactly what i needed!

[pbaldy]

Happy to help, and welcome to the site!

[Dalagrath]

Nice stuff there Pbaldy. I love using your website for quick info.

Also, mark the thread Solved please.

[pbaldy]

I'm glad you found it helpful!