[FX.php List] Update a field in all related records.

[Greg Lane]

Joe,

You could do all of this through FX.php, but my recommendation would  
be to write a FileMaker script to do the work and then simply call  
that script from FX.php. It will be simpler to write and debug and  
the performance will likely be better as well.

Feel free to ask if you have questions about writing the FM script or  
calling an FM script from PHP.

Greg


On Mar 14, 2006, at 7:48 AM, Scarpetta, Joe wrote:

> I’m adding a button to a layout that needs to trigger the following  
> action:
>
>
>
> I’m currently on the parent record.  So from here I need to:
>
>
>
> Update the field ‘vote to’ Affirmative on the parent
> Set the field ‘submitted_date’ to Today.
> Goto to the Related records based on the key that is stored as $recKey
> Update the field  ‘vote to’ Affirmative on the child records
> Goto to a new page showing the parent information as a confirmation.
>