I have a contact_address (CA) table that collects addresses for a contact. I would like to upload those addresses to a text field in the contact table for convenience.
The table trigger when a user inserts or updates a record in CA table is supposed to loop through the addresses and put those into a field in the contact table.
In the loop shown, if a contact has 2 records in the CA table, the result is two copies of the same address, the inserted record. How do I get it to iterate through the CA records rather than repeating the same address twice? Thanks so much.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Sam23
I have a contact_address (CA) table that collects addresses for a contact. I would like to upload those addresses to a text field in the contact table for convenience.
The table trigger when a user inserts or updates a record in CA table is supposed to loop through the addresses and put those into a field in the contact table.
In the loop shown, if a contact has 2 records in the CA table, the result is two copies of the same address, the inserted record. How do I get it to iterate through the CA records rather than repeating the same address twice? Thanks so much.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.