I have a database that can be thought of as a Bill of Material database. I have controls for Assembly, ProductLabel and CartonLabel.
ProductLabel and CartonLabel are both setup as combo boxes, getting their data from a common tblLabels. For a given Assembly, the ProductLabel and CartonLabel can be the same label, or they can be different, or one or both can be blank.
I need to create a query that will show me all of the Assemblies that a given label is used on, whether the label is used in ProductLabel or CartonLabel or both.
I know how to create a simple parameter query, but I don't know if what I need can be done. When it comes to VBA, I'm a total rookie.
Any and all help will be greatly appreciated.
ProductLabel and CartonLabel are both setup as combo boxes, getting their data from a common tblLabels. For a given Assembly, the ProductLabel and CartonLabel can be the same label, or they can be different, or one or both can be blank.
I need to create a query that will show me all of the Assemblies that a given label is used on, whether the label is used in ProductLabel or CartonLabel or both.
I know how to create a simple parameter query, but I don't know if what I need can be done. When it comes to VBA, I'm a total rookie.
Any and all help will be greatly appreciated.
