Medron Posted March 11, 2018 Report Share Posted March 11, 2018 I would like to create a triggered action that inserts a client's "random ID" onto other tables with the same client's first and last name. I have tried on my my own without success. Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted March 12, 2018 Report Share Posted March 12, 2018 Look at this screenshot: http://joxi.ru/DrllwvKC470OJr Note, if you have created relationships between you tables, enforce referential integrity should not be checked as trigger fires before inserting data to the parent table so the data in child table is being considered orphan and cannot be added Quote Link to comment Share on other sites More sharing options...
Question
Medron
I would like to create a triggered action that inserts a client's "random ID" onto other tables with the same client's first and last name.
I have tried on my my own without success.
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.