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

Topic Labels: Base design
368 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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