Help with a calculated column (lookup function?)

Good morning,    I have a table (Product_Structure) that contains repeat part number combinations (Parent Part + Child Part) because it esentially keeps a log of all the times the part number pairi...