Question Auto populate HELP

[RustyRick]

In Access 2010, Win 7. I have 2 tables. Very simple.

1) tblEmployee Fields: EmployeeID (KEY) , FirstName, LastName, Site, UnitNbr. That's stagnant data, as it rarely changes. But there maybe several hundred employees. The only thing that might change is the "Site" and "UnitNbr".

2) tblLogBook This is a daily record of the hours applied per day in 4 categories per employee. However this record needs the EmployeeID to identify who the record belongs to. So I have a "Foreign Key" identical to the "Key" in the tblEmployee. The KEY is a AutoNumber.

So each record needs to show 1) Unique "Auto Number" (Key); 2) who the EmployeeID; the date; Hours 1, 2, 3, & 4; UnitNbr; & Site.

So what I'd like to do (head banger) is design my data entry form to populate the tblLogbook.

When I open it, I start with a Date pick. Then I'd like to type in the "EmployeeID" and have it AUTO populate the "UnitNbr", and the "Site" assigned to him.

My relationship currently is from the tblEmployee (EmployeeID) [Key]; to the tblLogBook (EmployeeID) foreign key.

I've spent days trying to build this form. It's been a real :banghead::banghead::banghead:

 

[RustyRick]

thank you in advance. Makes sense, but it's bed timed now. And later for you. I'll be back tomorrow.

 

[RustyRick]

I need help with the "Lookup" function.

I think that my process is to leave the "Data Type" as "Text" in the "Design Tab". But go to the lower half of the "Design View" screen and in the

Display Control - choose Combo Box. In the Row Source Type choose "Field List", and in the "Row Source" choose the qry name.

Is that correct?

 

[RustyRick]

Thank you so much, a pivotal point for my DB