Ralf,

You need an inner join. You can read about this in SELECT - SQL. You may need to make your own query rather than using the query from the wizard, though you can use the report from the wizard.

SELECT Father.*, Son.* ;
FROM Father INNER JOIN Son ON Father.Key = Son.Key ;
ORDER BY Whatever

- OR -

SELECT Father.*, Son.* ;
FROM Father, Son ;
WHERE Father.Key = Son.Key ;
ORDER BY Whatever


>Hi,
>
>I have tried using report wizard to list one-to-many data. It is OK but it will also list those father records with no son. Is it possible to list records with sons only?
>
>Regards
>Ralf