2 Replies Latest reply on Apr 16, 2015 11:39 AM by ToddNolan

    Table Duplication

    ToddNolan

      Title

      Table Duplication

      Post

      Ok Guys, I hope you can point me in the right direction.

      I want to create a new table in a database that consolidate parts of two different tables.

      Example: I have Table 1: includes name, age, gender, etc

                     Table 2: includes zip code, status, etc

      How can I copy a few fields from each table into a third table and keep it up to date?

      Should I create a new table and just populate it with lookups?

       

      Thanks for you time and help.

       

      Todd