Relationships and tables! Take a look at my new relationship diagram please.
I am trying to make a stock control system for a small shop that takes order as well as "normal" transactions. Have i made the correct relationships between them? I have several tables all connecting to the same field in the same table. Is that OK?
Relationships picture
Thanks for all your help Martin.
I am trying to make a stock control system for a small shop that takes order as well as "normal" transactions. Have i made the correct relationships between them? I have several tables all connecting to the same field in the same table. Is that OK?
Relationships picture
Thanks for all your help Martin.
Last edited: