Flowers4Algernon Posted April 9, 2021 Report Share Posted April 9, 2021 Hi everyone. Just wanted to share this triggered action that would satisfy the following conditions: Update Table 2 with the Agent's name under corresponding location field Only update when Table 1's Assigned yes/no field is checked Records should have equal Store Number Quote Link to comment Share on other sites More sharing options...
0 NiceDuck Posted June 16, 2021 Report Share Posted June 16, 2021 I'm not sure if that is intended but you are using both #inserted.Store_No with your join conditions. This trigger will update all of your record on the 'Table_2' with whatever the values you have on your #inserted. Unless its intentional, it is going to create a mess. Make sure to backup your tables. Quote Link to comment Share on other sites More sharing options...
(1).thumb.png.f8c9f921c64f52a6ccaa487392105c26.png)
Question
Flowers4Algernon
Hi everyone.
Just wanted to share this triggered action that would satisfy the following conditions:
Link to comment
Share on other sites
1 answer 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.