I have a database which will track "Current Hardware", "Added Hardware", and "Deleted Hardware" and Each of these will have different fields, such as "SerialNo", "aSerialNo", and "dSerialNo". I have 3 separate layouts which contain the separate fields. If I need to add a piece of hardware, I would like to add it using the "Added Hardware (aSerialNo)" layout, which will also add it to the "Current Hardware". These can't be the same fields, because the "Added Hardware" layout should only show the items that were added since a certain time, not all records. If I need to dispose of a piece of hardware, the item needs to be added to the "Deleted Hardware" and removed from the "Current Hardware" In other words...all the "Current Hardware" field contents (SerialNo and others) would be cut and pasted into the "Deleted Hardware" fields (dSerialNo and others). Now that I have probably completely confused everyone (and myself ), I would appreciate any help that anyone can give.

Thanks,

Attach a little part of your table/s here if it is possible.

I'd think one table, with a couple of date fields, should be enough.

I would get rid of "aSerialNo", and "dSerialNo". I would add a field Staus which would contain either Active, Added or Deleted.