Forum Discussion
MCFNeil
8 years agoQrew Captain
Yep, you are on the right track.
You will need to summarize the cheapest PRICE first,
>
then send that price back down to the joined table as a lookup field
>
Then summarize the minimum Record ID# with the condition of [Price] is equal to the value in the field [New summarized lookup price field]. Say its something like [Cheapest Joined Record ID#]
This will give you the record ID# for that joined record.
>
Then ( you create something that I really don't like doing, but for this case it might be the best option) you create a reverse relationship.
>
Each "Joined Table Record" will have many "Products", but for the field of the relationship be sure to use the [Cheapest Joined Record ID#]
>
then you can pass the name, and any other information as lookup fields to the Product table.
You will need to summarize the cheapest PRICE first,
>
then send that price back down to the joined table as a lookup field
>
Then summarize the minimum Record ID# with the condition of [Price] is equal to the value in the field [New summarized lookup price field]. Say its something like [Cheapest Joined Record ID#]
This will give you the record ID# for that joined record.
>
Then ( you create something that I really don't like doing, but for this case it might be the best option) you create a reverse relationship.
>
Each "Joined Table Record" will have many "Products", but for the field of the relationship be sure to use the [Cheapest Joined Record ID#]
>
then you can pass the name, and any other information as lookup fields to the Product table.