Autofill from previous combobox entry

[ITguy1981]

Table: Employees has a field employee and a field EmployeeID. Table: Daily Time also has a field EmployeeID. My daily time form has a combobox that populates employee name from the Employees table. I have an EmployeeID field on the form as well and I would like for it to enter the employees ID automatically when the employee is chosen from the combo mentioned earlier. I thought this is done automatically as long as a relationship exist between the two tables.

I currently have a one-to-many relationship from Employees,EmployeeID to Daily Time,EmployeeID with a join type of only include rows where the joined fields from both tables are equal. I've tried other join types to see if it would fix the issue and it didn't.

 

[MStef]

Look at "ComboImpoyeeIDA2000.mdb" (attachment, zip).
Look at Table1, Table2, Form2, Relationships.
Open Form2 and try.

 

[ITguy1981]

That helped a lot. Thank you. It also helped me find some flaws with how I was actually pulling and storing data.