[thelist] Foreign Key constraints

Anthony Baratta anthony at baratta.com
Fri Jun 9 09:36:21 CDT 2006


One way to deal with this is not to delete records from your reference tables. Use an active / inactive flag instead. This way as you assign new relationships you pull only those records that are active. And those that are inactive, still have a relationship - they just won't get more relationships assigned.

This way you don't have to worry about a field in the sense "what that not filled out" versus "did we remove data that is causing that field to be 'nul'".




More information about the thelist mailing list