Question

  • Creator
    Topic
  • #2148181

    Updating two Access Tables at the Same Time

    Locked

    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
    accountNumber,
    date,
    time,
    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?

All Answers

  • Author
    Replies
    • #2460322

      Clarifications

      by castejb ·

      In reply to Updating two Access Tables at the Same Time

      Clarifications

    • #2460269

      I am sure

      by john.a.wills ·

      In reply to Updating two Access Tables at the Same Time

      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?

      • #2460955

        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.

        • #2781979

          Linking Tables

          by pat.jablonski ·

          In reply to I still need to get it Done. We have flaws

          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.

Viewing 1 reply thread