Updating two Access Tables at the Same TimeLocked
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
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?