scottybwoy Posted August 25, 2006 Share Posted August 25, 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 Share on other sites More sharing options...
mr. big Posted August 25, 2006 Share Posted August 25, 2006 Since you already have a relationship between the value type and customer type in a table, I don't see why you'd want to have the exact same information in yet another table. Any work you need to do could be done by a query to the Purchase Order table. Quote Link to comment Share on other sites More sharing options...
scottybwoy Posted August 29, 2006 Author Share Posted August 29, 2006 Thanks, that's what I thaught just wanted to clear that one up. Quote Link to comment 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.