AnsweredAssumed Answered

how to get drop-down list from different table or layout?

Question asked by a_sun on Dec 27, 2010
Latest reply on Jan 3, 2011 by philmodjunk

Title

how to get drop-down list from different table or layout?

Post

Hi,

I have 3 .fp files

Jobtickets.fp
Line Table 
=> 
_kf_item_id

Inventory.fp
Inventory
=> _kp_item_id

Purchase Requisition Table
=> _kp_PRid
=> Line::_kf_item_id

Purchase Order.fp
=> PR::_kf_PRid
how to get drop-down list from Line::_kf_item_id in PO Table? Filtered by PR::_kf_PRid?
Meant in PO layout if i select PR id, item drop-down list will be show the related item not all the item list.

Any idea?

Thanks,
suisui

Outcomes