Reply to thread

Message: [QUOTE="EVA, post: 2582359"] Ok, I will try to explain. First I think the Brandname title was complicated I will name it producttype. So I have 8 tables tblBrandname Brandcode Partnumber Description Productype Packsize tblAssembly1 Partnumber Description Producttype Packsize tblAssembly2 Partnumber Description Producttype Packsize All other assemblies are like assemby 1 and 2 What I want to do is have two joints from tblBrandname to the Assembly table. Depending on the Producttype and the Packsize a list of Brandcodes should be made visible. Then if I select one of the Brandcodes, I would like to see the specific Brandcode and the assembly in a form (This will be my Bill of Material) Basicaly I want to query the tables every time and display the right Brandcode with the right assembly as a subform. Is this possible in access? Thank you in advance, Kind regards, Elena [/QUOTE]