Populating subform based on a selection from master form

[dboollu]

I have a master form that displays various Customer values (ie/name, address,
specs). I am adding three subforms. I am having trouble figuring out what
process I have to use to tie a CustomerName to a number that this company
uses as a sort of customer number called ACM#, to something called a Melt #.

So basically, the process is a user selects a CustomerName which
automatically populates specifics stored in the tblCustomerName and
tblCustomerRequirements including the customer number (ACM#) into the top
portion of the form. This is all populated via a CustomerName_ACM# query (a
look up query) which is the Record Source for the master form. Now I am
creating two subforms 1 containg results of a chemical analysis on the part
which results in 1 or more Melt#'s and the other containing the requirements
for the part (basically the elements (metals) that make up the part).

I think I need to create a query of some sort to relate the CustomerName,
ACM#, and Melt#, so that they automatically populate with the ACM# and
Melt#'s associated with this customer. In return also populating the
associated data in the subforms with the respective tblChemicalResults and
tblChemicalReqirements via the Melt#. Is this understandable??? I'm not
exactly sure how to do this. Do I create another look up query like I did
for the CustomerName? Or do I need to pass some type of 'criteria' in the
query or an expression of some sort in the property sheet of a control?

Thanks for any help!!

 

[roger]

if I understand the question:
Yes you need to build a query to link the tables for your subforms, it
should show everything you want each subform to show, but for everyone at
once. Make sure these queries include whatever customer ID number you use.

Your Main form is BOUND to to the Customer table, your subform is bound to a
query, and the subform is then LINKED to the main form by the customer ID
number.

then as the user pages through the customers, the subforms changes to show
ONLY the records that have that CustomerID.

is that what you want?