I have created a vehicle checklist database. On the form, i have created a tab for each shift for example, Day shift, mid shift and Evening Shift. I created Three Separate form for each shift, but they are on the Vehicle checklist form at a tab so i can view them all at once. When I input data such as the date and driver and mobile number, everything is fine. When i try to enter data into the tab and move to the mid shift tab, it give me an error message, "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field of fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. When i hit the undo button and try again its ok. Any Thoughts why it does this?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 8.