- I have created several user role types under the main Accounts role. I'll call these sub-roles here.
- I have added non-standard fields to each of the sub-roles but in the most part they are the same across all the sub-roles, e.g. Address and Phone fields.
- Updating a non-standard field in one of the sub-type does not update in the same named filed in the other sub-role tables.
What is the best way to synchronise the data from a record in one sub-role table to other records in other sub-roles tables where the User is the same (using the email address as the unique ID field)?