View Single Post
  #7 (permalink)  
Old 08-27-10, 10:08
MCrowley MCrowley is offline
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 4,899
You could enforce the relationship with triggers, but that would get very ugly very quickly. I would suggest that you create a dummy object in the master item table for the non-item rows in the child table to point at.

I agree with shammat. The data model appears suspect.
Reply With Quote