AnsweredAssumed Answered

Selecting a record by unique ID

Question asked by gjbdjc on Oct 21, 2014
Latest reply on Oct 22, 2014 by gjbdjc

Title

Selecting a record by unique ID

Post

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.

Outcomes