Retrieving data

[nsl]

I have a parent / child database, records that exist in the parent table may or may not have a record in the child table.

The form displays the parent data and the child data as a portal.

I need to list all parent records that have a particular value in the child table or do not have a child record at all.

Currently, the find option only displays the parent records that have a record in the child table and ignores the parent records that have no child records.

[RalphL]

Try adding a calculated number field = Case ( IsEmpty ( Chile::ParentID); 1; 0) Then do a find on this field.