Multi Updates

I have searched the forums and documentation but can’t seem to find an answer. I have two tables. When I update a value in the main table, I need all other related data updated in the second table. For example:

Table 1 -
ID. || employer_naics
9. || 45673

Table 2 -
place_employerid. || place_naics
9 || 45673
9 || 45673
9 || 45673
10 || 12345
11 || 56789

If I update the 45673 in the first table I need all records with the employer id of 9 (for example) to update the NAICS value in that table as well.

I think I need to use the multi update server action but can’t seem to find any info on how to use it. Is this possible?

Community Page
Last updated: