Two Tables, Two Servers, One Form

[sahaitu]

Greetings:

I have a database with a table stored on the backend and a shared server. These tables are linked to a form.

I would like to have the information inputted into the form placed into tables on the shared server and tables on a more private server.

I guess I forgot to mention, the information I want stored on both tables is the same, it's duplicative.

For instance, I want to store the staff name and ID entered into the form on the table on the shared server as well as a table on the more secure server.

The information has the same PK, though it is to be placed in two separate places.


Is this possible?

Any help is appreciated.

Thanks,
Sahaitu


Thanks