Updating two Access Tables at the Same Time

By castejb ·
I have two individual systems with their own databases running on our server.
Once system is for payment management and the other for customer control

I need that whenever a payment is entered and fields for
and RepresentativeID
are completed them to be added as a new customer automatically in the other system. When the data is copied I need the remaining fields to be added in the customerControl program by code (automatically).

Field names are not the same in each program and Primary Keys for the tables are not the same.

Is there a way I can achieve that?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

I am sure

by john.a.wills In reply to Updating two Access Table ...

that there is a way to do what you are asking for, but I am equally sure you have a bad design. Why not put both tables in the same database and use consistent names?

Collapse -

I still need to get it Done. We have flaws

by castejb In reply to I am sure

I do understande design flaws however this two programs where developed in different Time Periods of the. For anybody to go threw a system changing process a lot of documentation and papers have to go threw and that will eventually lead to other things. I was looking for a easy fix that could be implemented with the current set-up that we have so I dont have to go into restructuring what are allready operational and Stand-Alone systems.

Collapse -

Linking Tables

by pat.jablonski In reply to I still need to get it Do ...

Try linking the one set of tables in the database that contains the other set of tables and editing them that way. You can create a function that will copy the contents of one field in table 1 to another field in table 2.

Related Discussions

Related Forums