scottybwoy Posted August 24, 2006 Share Posted August 24, 2006 Hi all,Am working on a database project for my company and have pretty much everything set up. However I am unsure whether a relationship is needed here. Let me explain :We have different types of customers and have a table holding these that is related to the customers table. When a customer makes a sale the cust ID is related to that sale carrying with it the customer type. Then our products are given as a different price depending on their type. Do I need a relationship between the Cutomers table, value type to the Product table, value type?Does this make sense, the Sales table is connected to the Product table via Purchase Order key. Quote Link to comment https://forums.phpfreaks.com/topic/18530-relationships-question/ Share on other sites More sharing options...
Barand Posted September 8, 2006 Share Posted September 8, 2006 I'd set the relationship to the cust_type table type field. IF you print a price list, say, you need that one.[pre]cust_type customer sales product price---------- --------- -------- --------- ---------cust_type -+ cust_id -+ purch_ord +- prod_id --- prod_idtype_desc | name | prod_id -+ prod_desc +- cust_type +- type +- cust_id | price | | +---------------------------------------+[/pre] Quote Link to comment https://forums.phpfreaks.com/topic/18530-relationships-question/#findComment-88758 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.