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?
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?