relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a tabform located on a main form. One of my tabs has many subforms on
it. The subforms are linked to various tables. Example: AdhesivesTbl-
FieldID, ProjectID, AdhesiveID, Square Feet, etc.. There is a table called
products that all products are stored in. The productID has a one to many
relationship with the AdhesiveID. There is also a Project table that includes
a list of buildings The main form's source is this project form. I would like
to be able to scroll through records on the mainform which will scroll
through buildingnames so i can add products to the different buildings. In my
adhesive table i would like the projectID to appear next to the adhesiveID so
i know which products are being used at which buildings. Ideas?

Thanks
 
Make sure your query for the Product includes the building identifier. Link
Child Field the subform to the main form using the Master Field identifier as
building identifier.
Do the same for Product to Adhesive subs.
 
Back
Top