I have a table in Caspio "IDS_Export_Web_Inventory" that is automatically imported and replaced nightly. This table has a unique ID field [stock_number]. This is my parent table.
I have another table "Inventory_Inspections" with a unique ID field [Stock]. This is my child table.
How can I automatically append new records from "IDS_Export_Web_Inventory".[stock_number] that are not already in "Inventory_Inspections".[Stock] to "Inventory_Inspections".[Stock]?
I've created a task which seems to accomplish this goal but I'd like to confirm if this workflow will work and/or is the best recommended practice.
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
ChristianM
Hi All,
I have a table in Caspio "IDS_Export_Web_Inventory" that is automatically imported and replaced nightly. This table has a unique ID field [stock_number]. This is my parent table.
I have another table "Inventory_Inspections" with a unique ID field [Stock]. This is my child table.
How can I automatically append new records from "IDS_Export_Web_Inventory".[stock_number] that are not already in "Inventory_Inspections".[Stock] to "Inventory_Inspections".[Stock]?
I've created a task which seems to accomplish this goal but I'd like to confirm if this workflow will work and/or is the best recommended practice.
Thanks,
Christian
Link to comment
Share on other sites
2 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.