Replace data

christine

New member
Local time
Today, 07:51
Joined
Oct 14, 2009
Messages
5
I am somewhat new to access and I am having problems, I cannot figure out how to swap data in a table.
I have a table of equipment:

ID--Manufacturer-Model-SerialNmber-AssetNumber-LocationNumber

I also have a table for notes:

ID--Location Number-Notes-Date-ect.

If the equipment breaks we need to replace it, I can change the information, but then I loose the old information. How do I change the Manufacturer-Model-SerialNmber-AssetNumber and save it to a different table. Would it be better as a query or in VBA?
 
that's the point isn't it? why are old notes relating to old equipment related to new equipment?
 
It is required for us to keep records of all transaction, even replacing equipment. Notes are more important to the location of the equipment.
 
Hi Christine,

I don't know if this will fit the purpose: in the equipment table you could add an extra field called "status".

The status of a piece of equipment could be "live", "in repair", "disposed", etc.

(you can of course create a new table called "status" and store those status values in a table and link to the equipment table's status column)

You can then just copy the old equipment data and create a "live" status, and mark the old one as "disposed".

Later you can simply make a query to find out what is live, in repair, etc.
 
Thank you for replying, I will try that. Should I do that with an option button?
 
I suggest a drop down box would be better.

This is because it will give you a bigger scope (e.g. if you have more statuses in future, a drop down can fit much more without re-doing the form with those fiddly option buttons.

And the drop down box can draw the data from the status table. Bonus!
 

Users who are viewing this thread

Back
Top Bottom