One to many

[moundou]

I have 2 tables with a one to many relationship. One table with a family
name and one with individual members. I want to generate a report that is
filtered eliminating some individuals that do not want to be included. The
report is grouped to the family record. The queries that I have tried to make
combine the 2 tables eliminating the grouping. Is there a way to filter a
report - OR generate a query that preserves the one to many relationship?

 

[Jerry Whittle]

Put a Yes/No field in the table with the individual members called Excluded.
Put a checkmark in the Excluded field for all those individuals who do not
want to be included. In your query put No (without quotation marks) in the
criteria for the Excluded field. That will prevent those individuals from
showing.

However if all members of a family want to be excluded that family will not
show up. If you still need to see the family, even without members, double
click on the line between the tables and chose option 2 in the dialog box.

 

[De Jager]

I have 2 tables with a one to many relationship. One table with a family
name and one with individual members. I want to generate a report that is
filtered eliminating some individuals that do not want to be included.
The
report is grouped to the family record. The queries that I have tried to
make
combine the 2 tables eliminating the grouping. Is there a way to filter a
report - OR generate a query that preserves the one to many relationship?