Jump to content


Photo

Relationship Question *SOLVED*


  • Please log in to reply
2 replies to this topic

#1 scottybwoy

scottybwoy
  • Members
  • PipPipPip
  • Advanced Member
  • 532 posts
  • LocationUK

Posted 25 August 2006 - 08:47 AM

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.

#2 mr. big

mr. big
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 25 August 2006 - 08:08 PM

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.
"Every monkey thinks its children are beautiful."

#3 scottybwoy

scottybwoy
  • Members
  • PipPipPip
  • Advanced Member
  • 532 posts
  • LocationUK

Posted 29 August 2006 - 08:47 AM

Thanks, that's what I thaught just wanted to clear that one up.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users