Jump to content
  • 0
JanineB

Insert Data

Question

I have a simple table with "ID numbers" for the City of a specific Country. I have my main data table that includes a "ID number" field. How can I update all of the records in the main table with the matching ID number? I want to match up the ID numbers in each table in order to do insert of data on an empty field. Thank you!

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi @JanineB,

Tasks can be set to run at specific intervals during  the day, week or a month etc.  However, if you are looking for updating the empty values as soon as they are inserted, you can use a trigger. For this, create a triggered action on the main table based on an insert action on the table.  Then add a update trigger to update the inserted table field. Add a join to join the inserted table with the city table based on their ids.

Hope that helps.

Share this post


Link to post
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...