If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add data to table from form
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 |
#2
|
|||
|
|||
Add data to table from form
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/ex...tributors.html http://www.access.qbuilt.com/html/search.html __________________________________________ "Scott B" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|