I have a form that is based a table ("tblPartNumber").
I have another tlble ("tblPOPN") that I would like to use in a filter, if at all possible.
Bascially, tblPartnumber is made of of part number data (pricing, descrition, etc.)
tblPOPN is a table that links a Purchase order to a Part Number.
The form in question is a list of every part number listed one time. I want to be able to filter the form based on a combo box, in which I enter a purchase order number, and the form brings up all Part Numbers on the PO.
Is this possible?
I have another tlble ("tblPOPN") that I would like to use in a filter, if at all possible.
Bascially, tblPartnumber is made of of part number data (pricing, descrition, etc.)
tblPOPN is a table that links a Purchase order to a Part Number.
The form in question is a list of every part number listed one time. I want to be able to filter the form based on a combo box, in which I enter a purchase order number, and the form brings up all Part Numbers on the PO.
Is this possible?