Work Around Solutions Multiple Detail

starquest321 · Post by **starquest321** » Mon Sep 02, 2013 11:20 pm

Currently Phpmaker (V10) does not support selecting multiple records and updating the detail tables.
For example I select 10 master records and would like to choose which detail record fields to update.
What is a good work around solution?

mobhar · Post by **mobhar** » Fri Sep 06, 2013 1:39 am

Try this:

Create a View (database view is recommended) that will hold the detail records that includes the master key in each record,
To edit some detail records that belong to some master records, then use the "Basic Search" by choosing "Any word" option, and enter the keys value separated by the blank space in the search text box, then press Enter,
All the detail records will be displayed that belong to those master records, and your user can choose which record(s) will be edited using Multiple-Update feature.