I am currently updating an old MS Access Inventory database. I was wondering what the recommendation would be for inventory items when they are disposed. Would you create two tables (i.e. CurrentAssets, DisposedAssets) or would it be more efficient to add another field called Status? I would think the Status field would be more efficient. As of right now an item is copied to DisposedAssets, then deleted from CurrentAssets using a macro. Also, if I use the Status field, would I link it to a table, for example tblStatus, and put a StatusID field in this table along with a Status field (values=Active, Inactive, Disposed)? Thank you very much.
