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 (http://www.boomspeed.com/martinking/Relationships1.gif)

Thanks for all your help Martin.

Both ClientOrder and PurchaseOrder should be split into two tables. The Order header information and the order detail information. In every stock system that I have ever seen, orders can contain multiple products. Take a look at the northwind and orders sample db's. They are far from perfect, but they will give you some idea of how to structure your tables.

Thats given me a lot to get on with.

Thanks Martin