Join two tables which has different fields

[GigglyGirl]

Hi,
I need help. I am trying to figure out how to join two tables which they have totally different fields and make a new table out of it.

For example

Table1(with Records): PeopleID, tblPeoPedigree, Person, Father, Mother, Gender
Table2(empty this field could change): ATA25E07, ATA29C07, ATA42G12, ATA47D07, ATA4E02, ATA79C10, ATCT051, CTT003

Final table should be with this fields: PeopleID, tblPeoPedigree, Person, Father, Mother, Gender,ATA25E07, ATA29C07, ATA42G12, ATA47D07, ATA4E02, ATA79C10, ATCT051, CTT003

Thank you in advance

 

[FirstAndGoal4]

Just the fields or with data???

 

[GigglyGirl]

Well with data. And just to remind that Table2 could be anything.

 

[GigglyGirl]

Hey I got it.. Thank you anyway.
But I have another question how you change fields properties in VBA??