Multiple users & forms question.

[Bejo25]

Hey All,

Thanks in advance for your help. I searched through the forums, but was unable to find a thread regarding the issue I am having. Here is the scenario:

The database is for capturing production data between three shifts at a small warehouse. There are also 3 departments entering data per shift (at different times of the day.)


After entering data in the first form, I cannot enter data for the same date in the rest of the forms, because the primary key cannot have duplicate values (I have set the date to be the primary key). The supervisors need to be able to individually input their data for the same date, and I need to be able to run reports based on the date.
I have tried splitting the tables and setting up relationships, but so far have not been able to get it working either.

Once again, thanks for any help. Any and all suggestions are appreciated.
Also, I read forums all the time, but never post, so I apologize in advanced if I come accross as a newb.

Regards,
Ben

[TheShabz]

Is there an order to which people enter data when? For example, Lets say you have 3 people, person1, person2, and person3, and 3 fields, field1, field2, and field3. Does person1 always enter in field1 before person2/field2 before person3/field3? If so, you have the form for the first one, create the record, and the other two would run UPDATE queries to fill in the data, rather than try to create them.

[orange]

It sounds that you don't have the proper key set up.
What exactly are the fields in the records?
What makes a record unique?

If multiple records are added per Date, then Date is not the primary key.
You have to tell us more of your data and situation before we can help you.