assigning a transaction to a record

[token_remedie]

so I'm trying to work out the best way to tag a record if something has changed on it.
The main table has asset number and serial number, which both need to be checked cos one of the other can duplicate but not both at the same time. If they move locations then I need to keep a record that they've done so.

I've got the main records in the table now, and I'm looking at importing the redistribution spreadsheet. I was thinking something like this:

if Master.asset number and Master.serial no = import.asset and serial (Probably use an SQL join) then
for i=1
master.location = import.location i+1
next i
else
(copy the location and asset number to a transactions table and copy the new location name to current record)

would that work or is there a better way to do it?

 

[jdraw]

I suggest you create a data model. The first few topics at this site - normal forms, normalization and Entity Relationship diagramming -
http://www.rogersaccesslibrary.com/forum/topic238.html

Perhaps you could describe what your application is, so that others can understand your environment.