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