Thanks noeld, that works - in theory!

Unfortunately, the design of the system makes implementing this solution complicated.

I allow the user to set a variety of filters on each element...

Hi, These are all good solutions but I am trying to solve the problem using hierarchical recordsets! I have built a generic datamodel and the user designs their queries...

What about if you created an updatable view with ALL of the fields from both tables. If there was a 1-1 relationship wouldn't that work?

You mean a single line of SQL? I don't think so

I think the delete trigger method is better than writing a sp as it runs automaticaly. It also...

Hi, You could set up a delete trigger on the parent table which deletes related records in the child.

I use this method when i can't use the built in...

Here is an example of a SHAPE command that returns the qualifications records for all of the people

SHAPE { SELECT * FROM DT_PERSON }

APPEND({SELECT * FROM DT_QUALIFICATION} RELATE Person_ID...