1 of 1 people found this helpful
This is one of the (many) areas in FileMaker where a relatively complex workaround is reqruied.
Easy way - put a checkbox on the portal row, check the records requried and then run a script that isolates the reocrds, performs your actions and then clears the checkbox.
More complex way - checkbox is not visible, check for clicks/shift-clicks on portal rows (which is a button), set the flag field via a script on the button and then continue as in the "easy" way. Bonus points - add conditional formatting to display the fact that the portal row has been selected.
This is also dependant upon the fields on the portal row not being editable.
The programming is not overly difficult, determinging the workflow to fit within your system will likely be more difficult.
Thanks - I was hoping not to have to code a workaround like the ones you describe, but looks as if I'll just have to get on & do it...
It's actually a bit more complex than that - if you want to accomodate multiple users. You should use a global field or variable to hold a return-separated list of the selected rows' IDs. Make shift-click add/remove the clicked row's ID to/from the list.