k so basically we've got a bazillion assets that have been kept in spreadsheets and someone said hey man can you make us a database? SUUURE I said *raise middle finger*
Anyway so everything is kept in seperate spreadsheets, so I've got an import button that lets you select the sheet to import, if its a redistribution sheet then it does this:
1. check the assets -> serial numbers if theyre the same but location is different (thats the one you helped me with) then move the location from Master (the main table) to transactions (the history table) then update the master table location from the redisttable (the import table).
Master:
PK is UID - Autonumber - this is what I'll be using to reference an asset from here on once the asset is in because the serial number or asset number can be duplicated (its a shitty system)
Location
these two fields are the only thing I really need to work with the rest doesn't change
transactions:
PK is ID - set to number
I've been reading and apparently I can set the table to allow duplicates?
the queries work, I just gotta append the transactions table because I'm moving over UID and Location from master, if the ID field allows duplicates from the UID then when I reference back to it from a subform it can be based on form!master.uid to find all entries in transactions, list them and its then showing where that asset has been in the past.