Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to set field to only link to the records that met the criteira?

Topic Labels: Base design
142 0
Showing results for 
Search instead for 
Did you mean: 

Hello Community, First time here.

My database has supplier_table and item_table with pricelist_table as a junction table to create pricelist history between supplier, item, and date field. I create po_table to record purchase order and want to have a field to link to pricelist_table, but only link to the records that have the lastest date of matched supplier_id and item_id in the po.

For example,

0 Replies 0