A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Add data to table from form



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2006, 04:43 AM posted to microsoft.public.access.forms
Scott B
external usenet poster
 
Posts: 1
Default 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  
Old November 13th, 2006, 05:35 AM posted to microsoft.public.access.forms
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.