"Darren New" <dne### [at] sanrrcom> wrote in message 
news:48eb04fa$1@news.povray.org...
> Say you're doing some accounting stuff, and you have different kinds of 
> accounts, but you want a table of movements of money between the accounts. 
> I'm trying to figure out how to get the details of having a single record 
> split over one of any of several different tables to be enforced by 
> constraints.

You'd probably need triggers. It's hard to enforce a 1-1 relationship 
without.

Depending how many columns are only applicable to one account type, I might 
take a short cut and put everything in one table. It does depend though.

Post a reply to this message