Importing records from two separate tables
I have three tables I am combining into one (Table 1 and Table 2 into Table 3). I have copied and pasted all the fields from tables 1 and 2 into 3. I then changed the layout setup to pull records from that master table (3). I am then attempting to import the records. I import records from table 1 and that works fine. I then import records from table 2 and the data from the previous importing I did disappears. Is there a way to resolve this?