Repeated rows in query-form

[astraxan]

Hi, I have a table with families and a table with the members of the family.


when i make a query to find a family (and all the members to be shown) then it returns the record as many times as the members. i created a form based on the query but the same problem. how to hide the repeated rows ??

[llkhoutx]

Grouping the rows in your query may help.

Multiple rows are more often the result of a 1 to many join. The many side causes all the duplicates.

[astraxan]

thank you for your help. i finally made a subquery so as to choose the distinct values that are shown duplicated