Is this possible?

[MKDru]

I would like to make a database for inventory keeping and would like to know if all these situations are possible.

I would like to have multiple tables but have one main one that is updated by the others. I would have inventory in multiple places and sometime the inventory would be in more than one place.

So I would have a table for initial purchases, movement from place to place of some or all, inventory used, and inventory returned. All these tables would be used to keep and update a table with the up-to-date inventory.

I would also like to keep a temperature log of all the places so as to find out what the max and min temperature the inventory has ever encountered.

I can create tables and forms for the tables but do not know if the up-to-date table is a possible idea.

Thanks for any help or comments.

[NTC]

Well you ask if it is possible - and so the generic answer is yes. But there is some uncertainty in your description; when you state the inventory is in multiple places - are you saying you need to have multiple physically separated databases also? That would be a more complicated design.

I will advise, in the most general terms, that one does not 'move data' from 1 table to another. Instead one uses fields to indicate the differing 'states'.

Hope this helps a little,

[MKDru]

I have the databases in one location, but the inventory itself can be in one location or the same item can be in multiple places. I am trying to build a database that I can keep track of my inventory as it comes in, moves around and goes out. I would like to have one database that has the most up-to-date inventory but other tables that keep track of purchases, movement of the physical items, sales and returns.