All family members with one address

[Grams]

I have two tables. One holds the Family Generic information. Last Name, Address, Home Phone..... The second table holds each individual family member with mobile numbers and emails. I want to make a table from these that will have the family last name, then each member with mobile # and email and then the family address and home phone.

[June7]

You don't want a table - build a query that joins the two tables. Build a report that uses that query as RecordSource.

[Grams]

I am sorry I guess I should have given more information. I then want to use this table as a mail merge. So a report won't do it for me.

[June7]

Use the query for the mail merge. However, if you want all the family members for one family to show like a table in Word document, a normal mail merge cannot do that. Requires code to build a table in the Word document.

Alternative to merge could be export to Word RTF.

[Grams]

OK here are my tables. As you can see when I link and use a query my last name and home address shows up for each first name

Table 1
FamilyID	Last Name	Home Street Address	Home City	State	Home Zip Code	Home Phone
1	Smith	123 West Street	Chicago	IL	12345	(123) 987-9876
2	Jones	345 East Street	Parkville	NJ	76523	(234) 987-2653
3	Alberts	387 Overton Street	Westover	SC	56273	(253) 987-6543
4	James	298 North Avenue	Aster	TX	98761	(654) 987-2345
Table 2
Family Member ID	Family ID	First Name	Mobile Phone	E-Mail 1
12	1	Bill	(871) 234-5679	bill@123.com
13	1	Sue	(234) 987-1627	sue@abc.com
14	2	James	(463) 719-2842	james@yahoo.com
15	2	Elizabeh	(872) 346-7384	Lizzy@yahoo.com
16	3	John	(412) 334-5434	john@gmail.com
17	3	Karen	(348) 725-3647	karen@gmailcom
18	4	Sam	(998) 346-3433	Sam@yahoo.com
19	4	Sharon	(523) 434-5245	Sharon@yahoo.com

[June7]

Yes, that's how query works. An Access report can be set up using Sorting & Grouping features so that the last name and address info display only once.

Export the Access report to Word RTF or to PDF. Otherwise, complicated code to build table of family members in Word.