This topic is locked

populate detail table with data from other table

12/30/2014 12:44:26 AM
PHPRunner General questions
romaldus author



[b]



Purchase_order_header table

purchase_order_number
Purchase order_detail table

detail_id

purchase_order_number

material_number

material_description

quantity

uom
[color="#0000ff"]Second Master detail table (as you see in screenshot)

Screenshot below is an illustration about what i want to achieve.

I want when i enter a PO number in field (lookup from purchase_order_header table) and click the "Read Data" button, then the detail table populated with data from Purchase order_detail** table.
How i configure this in phprunner? Thanks.


C
chuckbower 1/22/2015





[b]



Purchase_order_header table

purchase_order_number
Purchase order_detail table

detail_id

purchase_order_number

material_number

material_description

quantity

uom
[color="#0000ff"]Second Master detail table (as you see in screenshot)

Screenshot below is an illustration about what i want to achieve.

I want when i enter a PO number in field (lookup from purchase_order_header table) and click the "Read Data" button, then the detail table populated with data from Purchase order_detail** table.
How i configure this in phprunner? Thanks.



It looks to me like you will need to add a custom code button and write PHP code to select the PO Detail rows into the other detail, then exit to your page again to refresh and reload the page.
Chuck