I have got myself into a mess regarding what should be a pretty simple setup, any pointers are appreciated.
At first glance it seemed straight forward but the more i think about it the more of a mess I got into
If anyone can advise a table relationship protocol that would be great.
- Customers can have several products (type A or B)
- The customer can be Husband and Wife (team) but may have a product together or separately
- A team will be allocated a specific team number which is totally unrelated to the products
- Products can be suplied by many suppliers
- The Husband Wife normally live at the same address so don't want to enter that in twice.
At first glance it seemed straight forward but the more i think about it the more of a mess I got into
If anyone can advise a table relationship protocol that would be great.