Relationship or something else?

[Mike CPB]

I have a table of workers.

I'm trying to make a table to track who worked.

Multiple workers in a day. A Days table.

I have setup the relation ship of WorkerID to each table but I'm not sure how to allow multiple reference's.

The number of people working per day varies from 20 to 80... Don't know if that info might give you some idea. Each day would be a new record in that table.

How do I create multiple relationship field's?

I'm guessing I might need a calculated result.

Regards, Mike.

[bcooney]

To resolve a many-to-many, use a table btw them, a "join" table.

So Days>-WorkerDay-

However, it isn't often I create a table of dates. Do they work on Jobs? Can you setup, perhaps, JOBS>-JobWork-