Inventory database question?

[s0n1c]

I am creating an Inventory Database, this is for all the computer equipment in our company. I have created tables for Inventory(that is out now) Available Inventory(Inventory being worked on and ready to go) Location (location for inventory). What I am trying to accomplish is to make a form that can move what I have in available inventory and replace what was in the inventory. EXAMPLE:
I have a monitor that blew up on the second floor with tag#001, Model, serial, date purchased, In my available inventory I have extra monitors with tag#002, model, serial, date purchased. How can I swap tag#002 and all info with tag#001 and all info, and send tag#001 to a holding or servicable items table. Is this possible?

 

[ghubbell]

Before we get too deep in to it let's take a sec and look at the structure once more. I think your table of inventory could just have an additional field True/False for "in inventory". If this is true it's in inventory. If false, its out there somewhere. Where? Check your "current location" field. If you really need more than two "states" scrap that first idea and use your table of locations: an ID number and a field for the description. On a form based off of your table, have a combobox that is based off your locations table and bound to your Inventory table's "LocationID". You would have to adjust #001 and #002 manually but even so, not much effort required. Ideas? Gord
ghubbell@total.net