How to create au autopopulating form

[hongman]

Hi

I have a simple database made up of the following:

Table Operative List - just a list of names
Table Project Name - just a list of projects
Attendance Register - Date, Operative Name, Project Name, Hours, Notes



I have a form which allows you to pick:

Date
Operative Name from dropdown
Project Name from dropdown
Hours
Notes

However it occured to me that instead of doing it like this for one entry per man per day, how would I create a form or something to automatically populate a table of all names in the list, all for the current day on one screen? This way I could just go down and enter the variable info such as allocating them to a project, inputting hours and adding any notes.

Would probably be a lot quicker.

Does this rambling make sense??

[orange]

You're telling us HOW to do something, but WHAT exactly is your database about?
You have People, Project and PeopleAttendedProject from my perspective. Typically these would be related
such as shown below.

People--->PeopleAttendedProject<---Project

It would be helpful to you and to readers if you could tell us in plain English what your business is; who does what;
when; how often etc so we get some familiarity with the"business" your database is intended to support. Best if you remove database jargon and just describe the business as you would tell an 8 year old.

It would also help with context if you took an example (Person) and (Project) and described what these are and what (Attendance) means in you business.

Also, it will be better for you (less errors with syntax) if you use names that do not include embedded spaces.

Here is a link to a Student Roster data model that may help with some concepts. Look at the Roster table and see how attendance is modeled and recorded.

Good luck with your project.