Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Access Multiple items relation help

25 Dec 2014   #1

Access Multiple items relation help

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???

My System SpecsSystem Spec
25 Dec 2014   #2

Windows 7 Home Premium 64 bit sp1

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.
My System SpecsSystem Spec

 Access Multiple items relation help

Thread Tools

Similar help and support threads
Thread Forum
Can I save multiple items on the clipboard in word
Hi, windows 7 prof. 64bit / office 2010 When i have been working on documents which require repetative entries and I copy these entries to the clipbpard, is there a way of saving these entries on the clipboard so when so that when I close the current document and open a new one that all previous...
Microsoft Office
Copying multiple items
I have a couple hundred songs I want to copy from the general Music library in iTunes to another playlist. What's the process for clicking on the first one and scrolling down to the last one and doing something there so that all titles in between will be selected so that I can control c and then...
General Discussion
Multiple items in the Windows clipboard?
Is this possible? Such as: Ctrl+c copies first object (or text) Holding down a key (let's say, Shift) along with Ctrl+c copies second object Ctrl+v pastes first object Shift+Ctrl+v pastes second object Or some other method.
General Discussion
Question in Relation to Dual BIOS
Hey Guys, I bought a nwe Gigabyte motherboard recently and it has a dual BIOS on it, If one of the BIOS fails for whatever reason then the back up one kicks in and takes over, The other day when I turned on my PC the Bootup screen said something along the lines of fail BIOS and did a download...
General Discussion
Relation Between Firefox & Chrome?
I only use Firefox 3.6.9. but decided to try Google Chrome. I noticed that Chrome can use some Firefox add-ons like Adblock and IE8 tab. Is there a relation between both browsers? Just curious.
Browsers & Mail

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 14:12.
Twitter Facebook Google+