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