If you are going to use this on a form, you could create a list box that would use the product code to select which parts have the selected product code as a match. If you are dealing with a report, you might be able to use the detail section of the report to build the list of all parts that can be used on the selected (or printing) product.




Reply With Quote