Currently Im getting this :
I Have another
I want to do one to many relationship with customer details and order no but before I can do that I am trying to add another order for the same customer but I keep getting that error message... anyhelp???
Hi 1nstan7, welcome to Windows 7 Forums.
Your Access problem is caused by your Order ID using a No Duplicates setting. This will not allow you to re-enter the same Order No. more than once.
You need to Open Tables in the Design View & reset Order ID to Duplicates Allowed. However it might be better to call it Order No. & allow Duplicates. It's best to use indexing as this speeds up data searches in the future, so don't use the No Indexing option.
Also you may want to add a column that shows which Customer that Order No. belongs to. As the same Customer will no doubt need to be entered many times with a new Order No. set it up with Duplicates Allowed.
Using the term ID in column description can be confusing if you are using an Auto Number for each entry.
If you need more help just ask. A layout of your main Table would certainly help, so a screen shot of that would help if you need more assistance.
Quote