AnsweredAssumed Answered

Table Duplication

Question asked by ToddNolan on Apr 15, 2015
Latest reply on Apr 16, 2015 by ToddNolan


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.