Table Relationship Problem

mickeyboy

New member
Local time
Today, 15:37
Joined
Jun 7, 2013
Messages
8
As this is my first post please forgive if I have posted it incorrectly!

I am relatively new to DB creation so forgive any ignorance. I recently created a database to help me manage my (Entry level) IT classes and manage all the documentation I have to produce. With a couple of small hiccups all seemed fine so I decided to expand for the other tutors to use. I recreated the first three tables exactly as the original but when I tried to add relationships between the tables I got One to One relationships where the original has One to Many.
(See attachment).

I have checked and double-checked all the field properties for both db's and they are identical....I am coming close to seeing how aerodynamic my PC is so ANY help would be greatly appreciated.

Apologies...attachment will not attach!!!!:banghead:
 
Last edited:
You may not be able to attach because of your post count. But if you make a zip file of the info, it should attach (at least that's the way I think it is suppose to work).
Good luck.

If it's exactly the same structure, you could try to copy the database and save with a new name. No need to build the copies from scratch.
 
Either the tables are not "exactly" as they were before, or you inadvertently tried to relate other fields than previously.

If both fields are indexed with No duplicates allowed then you'll get a 1-2-1 relation. If one has duplicates allowed, then you'll get a 1-2-M
 
Thank you for the reply...I had thought about just copying the db but I wanted to recreate to make sure I knew what I was doing.
What had me stumped was that I wanted to create a single entry form that added common data into the three tables without having to enter it three times.
In the original I managed (not sure how) to enter into 2 tables with a single form (no subform).
I will try Zipping the attachment but it still shows as over 100kb.
Thanks again.
 

Attachments

Thanks Spikepl...
I have managed to attach the screen print that show the relationship tables of both db's. The field properties are exactly the same.
 

Users who are viewing this thread

Back
Top Bottom