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
what is and its relation with svchost.exe?
I I noticed svchost.exe had a connection with "" for a couple minutes (via resource monitor). .ie is the domain end for The Republic Of Ireland, so location seems to match. It is linked to a company named eunet, which was bought by qwest. What is this? Is it a safe...
General Discussion
failed to access control panel items after windows 7 update
after the update,i cant access access the control even the windows update
Windows Updates & Activation
change startup items without OS access
accidentally installed Daemon Tools with SPTD emulation enabled on Win7 running under VirtualBox. RDP and Virtualbox are so seamless that I guess I thought I was on a regular desktop without builtin image mounting support. :o Can't boot into Windows (well, I get to the desktop and it restarts)....
General Discussion
Access IE9 Non-Visible Menu Bar Items
In the IE9 menu bar are items : File Edit View Favorites Tools Help Favorites I can access via the 'star' icon in the upper-left region of the window. I want to know how to access the others w/o enabling the menu bar, if it's possible. thnx,
Browsers & Mail
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 20:34.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App