Hi Michael,
If you are using VFP 5 or 6, why not use LEFT OUTER JOIN to each of the child tables?
>My app has a parent table (A) with several child tables (B, C, D). Some parent records do not have associated records in on or more of it's child tables.
>
>I use a SQL statement to a cursor for searching purposes. I know I can probably write a seperate SQL statement to get parents without children in table B but WITH children in C and D, and then another without children in C but with children in B and D... etc - and do a UNION between them all - but that's hard to write and hard to maintain!
>
>Has anyone come up with a better way?
>
HTH,
Bill Armbrecht
VFP MCP