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

    Table Duplication



      Table Duplication


      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.