create a form with mutiple fields

[Hal1968]

I'm pretty new to this stuff .. so bare with me . I've created some tables ,
first one consisting of manufacturer names in one feild , second one
consisting of manufacturer products , each feild related to seperate
manufacturer. Now when i create a form i can look up 1 manufacturer name but
in the products lookup in the form i can't seem to seperate the products in
relation to the manufacturer look up feild , I know it has something to do
with the way i got the query working , but that is my weak spot , unless i
need to create seperate tables based upon each manufacturer? I need a push
in the right direction , thanx in advance

 

[Bob Quintal]

I'm pretty new to this stuff .. so bare with me . I've created
some tables , first one consisting of manufacturer names in one
feild , second one consisting of manufacturer products , each
feild related to seperate manufacturer. Now when i create a form i
can look up 1 manufacturer name but in the products lookup in the
form i can't seem to seperate the products in relation to the
manufacturer look up feild , I know it has something to do with
the way i got the query working , but that is my weak spot ,
unless i need to create seperate tables based upon each
manufacturer? I need a push in the right direction , thanx in
advance

your table structure should be good, Manufacturers, with id,
manufacturerName, Address, etc.
and parts, which has the manufacturerID, the part number, and
partName, cost, weight, etc.

Your form wants to be based only on the manufacturer table, but
includes a subform based on the parts table, linked through
manufacturerID.