This topic is locked

Populate master child record data

5/7/2015 9:44:42 AM
PHPRunner General questions
W
wijninga author

Hi,
I am trying to create a screen where a user selects a purchase order which then pulls all the line items, put that in a screen where they can select (using a check box) if the line item came in, together with the number of items that came in and save that to another table.
Now the thing I am struggling with is how to populate the data. I think it would be easiest to select the child records and once checked by the user, save only those records in another table.
Does that makes sense, or is there an easier way and am I just overcomplicating things?

Sergey Kornilov admin 5/7/2015

You can add a custom button to the list, select a few records and then click that button. Here is the code sample that comes the closest:

http://xlinesoft.com/phprunner/docs/update_multiple_records.htm
Instead of updating the underlying record you can insert a record into another table. $data["FieldName"] gives you access to any field of selected record.