View Single Post

   
  #10 (permalink)  
Old 02-29-2008, 07:27 AM
pb648174
 
Posts: n/a
Default Re: multiple foreign keys on same field, based on other field

I was hoping to use foreign keys so that replication would be smart
enough to pick up all the relationships.. Will replication correctly
handle triggers automatically or will I need to setup something special
for this scenario?

How would you even accomplish Hugo's suggestion for a "has-a"
relationship? His involves setting the foreign key on the
BidItem/Adendum tables which would be a one to many instead of a many
to one relationship.

Reply With Quote