Hi,Not sure if title accurately matches my question. I have 2 tables linked by "Part Code":Table 1: Parts. Columns: Part CodeTable 2: Offers. Columns: Supplier Name, Part Code, PriceIn Table 1 I would like to add columns that automatically select the...
OK I'm able to create the Column "Cheapest Price" in Table 1 using a Rollup field for Price with formula MIN(values).But "Cheapest Supplier" I'm stuck with the fact that a Lookup field doesn't allow dynamic conditions. I would need it to have a dynam...
