Re: Archiving records question

Just store the price in the Item Details table. This isn't redundant, as
you are storing the price *as it was at the time you selected it*. If you
look in the Northwind Sample database, they show how this is done in the
Order Details table and form, where the user selects the product, and the
current price is automatically stored along with the product in the Order
Details table.

--
Joan Wild
Microsoft Access MVP
"Slez via AccessMonster.com" <u23064@uwe> wrote in message
news:6d06251ef0f3b@xxxxxx
I'm debating (with myself) whether or not to archive records in a database
and would like to hear opinions on what others may have done, or what
others
may think is best for my situation. I need to explain what I'm trying to
achieve.

I manage a database that we use for estimating projects. It's a fairly
basic
structure:
(1) Project > (Many) Items > (Many) Item Details
One of the fields in Item Details is "ProductDescription" wher users can
select from another table called Product. Each record in that table has
an
associated UnitCost.
So ultimately there is one record in the Product table related to many in
the
Item Details table.

Periodically, as with any business, UnitCost of a given Product is
adjusted.
This in turn changes the amount for a project because the Products
selected
change in cost.

My thought is that in order to "lock in" the UnitCost as products are
selected and added to the items on projects, I'd need to append these to
another table or even another database. Does that sound logical, or is
there
a better way to lock these prices in once selected?
Any thoughts or suggestions are appreciated?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200701/1



.

Relevant Pages

  • Re: Access Web Application
    ... The items table in our sql database has about 30,000 records, and there are ... Facilitate Produce Price changes. ... All invoice pricing to be entered from invoices as is done presently. ... Create an interactive form / report for P.O.'s with no paid invoice ...
    (microsoft.public.access.modulesdaovba)
  • Re: Record Locking
    ... If so, what lock ... "Multiple users open instances of the front end for simultaneous data ... database without any conflict at all. ... but had a field called Price which needed updating by increasing ...
    (microsoft.public.access.queries)
  • Re: Form calculation is not working
    ... My company is too cheap to get a proper database manager in, ... OrderDetails contains a field called Price. ... You cannot sum a calculated control, but you can sum the calculation ...
    (microsoft.public.access.forms)
  • Re: Help! Difficulty understanding DB -> Object mapping
    ... In your transactional database, the schema must be ... The product title (and price) can be retrieved by a very ... direct (using ADO) or indirect. ... >> This seems like too many queries... ...
    (comp.object)
  • Re: DLookUp for multiple forms
    ... If your cboProduct includes a column of Price, ... As in Northwind, an Order is the main form, and the OrderItems ... Jeff Boyce ... I refer to the Northwind database all the ...
    (microsoft.public.access.forms)