Storing Information in Two Separate Tables

[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.

Is this possible?

Any help is appreciated.

Thanks,
Sahaitu

 

[PHV]

All linked tables should not necessarly lies in the same external DB.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sahaitu]

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.

Thanks