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

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,
2022-04-08

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.