Report from Two Tables

S

Sannas1

Hello,

Any help would be GREAT for this!

I've built a membership DB. I have two tables, one for the primary members
and one for the family members. They have a common key so they can be linked
together.

I'm trying to create a report that lists the primary members (which I've
been successful) and then lists the family members directly UNDERNEATH the
primary members (kind of like a subset). I've been unsuccessful with this.

Is this possible?

Thanks!

Sannas
 
M

Marshall Barton

Sannas1 said:
I've built a membership DB. I have two tables, one for the primary members
and one for the family members. They have a common key so they can be linked
together.

I'm trying to create a report that lists the primary members (which I've
been successful) and then lists the family members directly UNDERNEATH the
primary members (kind of like a subset).
Click to expand...

The key to most issues with reports is to first get the data
properly organized.

In this case it looks like all you need to do is create a
query that joins the two tables:

SELECT members.name, . . .
family.person, . . .
FROM members LEFT JOIN family
ON family.foreignkey = members.primarykey

Then the report can use Sorting and Grouping (Veiw menu) to
group on the members.primarykey field (with group header).

Place the member data text boxes inthe group header section
and text boxes for a family menber in the detail section.
 
V

vag

Did you tried to add a subform or a subreport from the toolbox in the main
report and did not work? what was the problem?

Ο χÏήστης "Sannas1" έγγÏαψε:
 
Top