Add data to table from form

[Scott B]

Greetings,

Please tell me if this is a possibility or if it is a dumb idea. I have an
inventory list table and an inventory location table and a inventory date
table. I have created an inventory table that I want to get the data for
from a form that use the other three tables. I choose an inventory item, a
date and a location in three unbound lsit boxes on a form. I want to put
that data in a the inventory table so I can keep track of the inventory over
time. The inventory table has an autonumber priomary key. Each of the
other tables has a foreign key to the inventory table. Do yo need any more
info?

Thanks in advance,
Scott B

 

[Tom Wickerath]

Take a look at Access MVP Allen Browne's tutorial on this subject:

Inventory Control: Quantity on Hand
http://allenbrowne.com/AppInventory.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________