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