Re: [sqlite] Trigger update of multiple columns

[T&B]

Hi John,

A general rule of database design is to seperate reference and  
transactional data.  Then you can have a normalized database in a  
dynamic environment.

Yes, I think that's what I am designing.

The reference data is the products table (and potentially customer  
table etc)

The transactional data is the sale_products table which lists what  
products went with each sale.

Or do you mean something else?

Thanks,
Tom


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------