Re: Duplicate record
Re: Duplicate record
- Subject: Re: Duplicate record
- From: Arturo Pérez <email@hidden>
- Date: Thu, 22 Jul 2004 20:44:22 -0400
On Jul 22, 2004, at 8:08 PM, A. Uchida wrote:
Im making a quote database.
When a quote record is produced product data are going to be picked up
from Product table.
But Product detail (price or description of a product) will be changed
case by case or in the future
but the old quote record which had been already created should not be
updated by the modification.
When I had this problem I declared Product to be immutable. Whenever
the sales people (marketing whomever) were "updating" a Product they
actually created a new one. This solves your problem I think.
The key here is to conceptually separate the Product primary key from
the alternate key that the person updating the record sees.
----
WO in philadelphia - wanna cheesesteak with that?
Please visit webobjects.meetup.com.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.