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