Selecting a record by unique ID
I have a table for pricing my products. A single product my have several prices based on size of run and packaging. So Product 1 with a 100000 unit run, packaged in 25 unit cases will be one price, Product 1 with a 500000 unit run, packaged in 100 unit cases will be another. My table has a unique identifier for each scenario:
CostID1 = Product 1 - 100000 units - 25 unit case
CostID2 = Product 1 - 500000 units - 100 unit case and so on......
I need to link each production run to a specific Cost ID as they are always different?
I have a unique identifier for each run in an Invoice Data table.