T&B wrote:
Yes, that's what I'm doing. I just want to make it more efficient.
Technically it's the sale_products table (since each sale has many
products etc), but yes, I want to insert the transactions data
(product_id, buy, sell, desc) into the sale_products table. But I want
a mechanism whereby if I enter the product_id, then the buy, sell,
desc columns are auto entered (copied) from their corresponding row in
the products table.
Tom
I have probably misunderstood much of this thread, but I think how I
would handle this situation is to keep each version of each product's
description in the products table, along with the date that description
became valid. Then the product ID and date in each transaction would
reference the appropriate product table data.
That seems to fit "normal" database usage better than what you describe.
HTH,
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
