Viewing 8 posts - 1 through 8 (of 8 total)
If I understand correctly I must move the customer record that is used on the order to the Order Table (in our example the Customer name, Customer address ...).
September 26, 2007 at 11:17 am
Yes previous orders shoud be recreated with the data that was on the order when it was placed. So in the case of the address, if the address of...
September 26, 2007 at 8:25 am
It is the same table. Moving the address to a CustomerAddress table will solve this but what if the customer name changes? You will end up with a table for...
September 26, 2007 at 6:28 am
Ok problem solved. First my query is a complex one where tables are joined and then merged (union) with another – so Koji is right...
June 4, 2007 at 4:48 am
Grasshopper,
The customer details(name or address...) on the quotation after it is complete should never change. So the problem is if the customer details change after the quote is comple there is no...
March 15, 2007 at 12:04 pm
I totaly agree. To keep referention integrity all the tables have PK, FK relations but tables like the orders and prudcts, the enforce cascade delete and update option is off. So...
July 11, 2006 at 11:19 am
What if I keep the PK , FK relationship between Orders and Products and add a new table OrderHistory wich will keep all the orders placed data. In the end if...
July 11, 2006 at 2:24 am
Viewing 8 posts - 1 through 8 (of 8 total)