form

[pascal]

I have two tables "Employees" and "Tasks".
Now, I want to have a form on which I want to fill in the task of all the employees every day. Every employee has a different task. Every employee has one task for the hole day.
When I open this form I want to see the employees already filled in so that I just need to fill in their task. How can I make such a form.
Thank you very much.

 

[Jack Cowley]

I would suggest a Form/Subform. Main form is based on the Employee table and the subform is their tasks and based on the Tasks table. I assume that a one to many relationship already exists between these two tables so you can use the Wizard to create your form/subform for you.