Is there a way to show related Part Numbers when selecting a Part from Inventory?

I have an Inventory app that consists of a Master List of Costs (parent) and Inventory (child) that are related by Part Number.  When a Part Number is chosen from Inventory, we want to see a list of r...