Auto Populating a form FROM a table

[yepwingtim]

I have a table with Employee Name's
lets say ID | Name

I also have a table that also has a form to show if the employee has checked in or not.
ID | Name Reference | checked in

Everyday I go into that form and plug in every employee's name manually and check if they have checked in or not.

Is it possible to populate every employee's name in the employee name table into the form. instead of me manually inserting in every employee's name every time

Thanks

 

[ted.martin]

The simply answer to your question is run an append query of the Employee's names into your table BUT ..... Access is about relational databases so there should not be a need to keep enetering these Employee Names.

You need an Employees table and from linked to an Attendance table and sub form called (say) Attendance. The Parent/Child links being the Employee ID.

Then all you need to do is flick through the Employee records and in the associated SubForm, just enter the Times.