problem with query on sets

[Graham Wickens]

I have a set where the Parent Table is linked to the Child table by "one-to-many". How do I built a query that will return all Parent records that have Child records?

[Tom Cone Jr]

Graham,

I think the quickest solution would be to design a new set, inverting the order of your tables so that the child table becomes primary, and the primary table becomes the child, linked one to one.

An alternative would be to write a script which steps through your original primary table one record at a time. As each is fetched the script would look to see if there are linked child records. If there are the primary table record would be marked. When all are processed a query could be run to show only the marked records.

-- tom