If you can automatically enter data then you are violating the
normalization rules. Maybe you should get a book on database design and
become familiar with some of the fundamentals.
T&B wrote:
Hi John,
You have a reference data set which is accessed to get the current
value of reference elements and store transactions to record events.
The transaction trails provide event history.
Yes, agreed.
A price is in the reference data, its value transferred to a
transaction is no longer a price, it is a sale which represents the
value of the price at the time the event occurred.
Yes.
How about reading your price data etc and just inserting a
transaction into your sales table?
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
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
