Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 31, 2012 02:40 PM by mth13
May 31, 2012 01:38 PM|LINK
A noob question.
Suppose I have 2 tables where 1 is an associate of the other, lets call them Deals and DealTerms.
Is it better to do this:
and have a relationship between DealId and DealId
and have a relationship betweeb DealTermsId
May 31, 2012 02:40 PM|LINK
If all records in both tables will have the same DealID between rows, do it the first way. No point in storing the same information twice. Just make sure you don't leave orphan records between the two. You can set up the database to have a casading delete
between the two tables if you need it that way.