AnsweredAssumed Answered

Getting the latest price in fields, filtering by Supplier

Question asked by alenreggie on Aug 7, 2018
Latest reply on Aug 8, 2018 by Mike_Mitchell

I set up these two related tables:


Table 1: Products

Field A: Primary key

Field B: Product Name

Field C: Supplier A price

Field D: Supplier B price


Table 2: Price tracking

Field A: Foreign key

Field B: Date

Field C: Price

Field D: Supplier // Entering Supplier A or Supplier B name


(This table I'm using to track the changes of the product prices)



How can I get the latest price from 2C into 1C (and 1D also) from the record in 2, filtering Table 2:Field D by Suppliers?