Simple question?

[Aerowolf]

I've got 2 tables; Employees and Timesheets

On a form I want to display a list of the employees on the left of the screen and the timesheet entries on the right. When the user selects the employee, the correct entries show on the right. I want to be able to add to the timesheet entries.

I can make it work if I use a normal text box for the employee and page up and down through it, but when I try to change the text box to a List box and specify the source as the Employees table, I get an error (duplicate error) after I select the employee and tab out of that field to go into the timesheets side.

Help!

 

[GingerR]

I would make the Employee bit a subform. On the main form, put a text box that has a control source of

=[EmployeeSub]![EmpID]

(=SubFormName!FieldNameInTheSubform)

Name that text box txtChosenEmpID.


then for the Time Card Master/Child Links,

Child = EmpID (or whatever you call it)
Master = txtChosenEmpID

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html