Automatic Lookup

[Guest]

I have three tables : 1 is Master containing Product Info
2 is SubMaster containing Delivery and Production Formatted Fields for later
input as a job progresses
3 is General Table with results of the above 1 and 2
I need a Drop down Box to Select Product number/Name on a Form and populate
all other boxes automatically. and then add other info Batch no/Date etc
I also need on the same form all the Field information from SubMaster which
at creation has no data in it.
The combination from this Form need to be written back to the third Table
for later access and review/change by selecting the entry using a batch number
How do i use a form to get the infor from the first two tables and then
write back to the third

Thank you for any help provided

Jack

 

[Ken Snell [MVP]]

Let's start with your first desire...to select an item in a combo box and
have other values based on that item be displayed in textboxes.
See this article on The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm

As for the other question, I believe what you want is a subform that is
based on SubMaster table? But it's not clear to me what you are trying to do
on the form, so post back with more details and descriptions.