I have one database that is used mainly for data entry, and another database that's a read only repository. Both databases have the same fields. Once records in the entry database are approved by a supervisor, they are to be transferred to the read only repository. I have a view that shows approved records. I'm looking to create a "send to repository" button that calls an agent. How should I go about programmatically transferring these approved records to another database?
If possible, I'd like to be able to run a reconcilliation report to verify that all approved records transferred. Much of the time, these recent data entries need to replace records that are in the repository ( they're updated).
Thank you in advance.