Moving data from one table to another?

[Maverick1501]

Hi,



I'm creating an inventory database which keeps track of all my stock and where the stock is. What I would like to do is to be able to transfer stock from the main store to an engineer. I have a table called 'inventory' and multiple tables for the engineers - 'engineer 1', 'engineer 2', etc. Is there an easy way I can do this that also tracks the movement other than physically editing both tables?

Any help would be much appreciated!

Thanks.

[RuralGuy]

The simple answer is NOPE!

[NTC]

the correct way isn't to have tables by engineer ; but instead have a field in your inventory table into which you put a unique engineer's ID for every record; thereby assigning ownership of that stock.

then if you want to look up the stock of engineer ABC - you simply do a query with the criteria of that field as ABC.