MySQL Forums
Forum List  »  Newbie

Re: Table design question
Posted by: Hartman Wagner
Date: April 20, 2005 11:53AM

Preston,

I have it working where the joining table only has 2 columns, CustID and TypeID each one being a foreign key. This works fine but I can add many records with the same data same CustID and TypeID, how do I stop this?


Table CustID ----> CustTypeID <-----TypeID
CustID ----------CustID/TypeID <----TypeID

Thanks
Hartman

Options: ReplyQuote


Subject
Written By
Posted
April 19, 2005 11:20AM
April 19, 2005 06:04PM
Re: Table design question
April 20, 2005 11:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.