I have a grid which works fine when there is existing data in the tables.

I am using the set filter rather than having parameters and I'm hoping that isn't the problem.

Depending on which radio button is selected the filter is changed. I do a count on how many items apply and if it's 0 then I add a new record. After adding the new record I seek the parent to activate the relationship (defined in the database and the dataenvironment, OneToMay is .t.). What I get is my new parent record but 2 child records, neither of which belong to the parent. There should only be 1 child.

Any ideas. This is holding up the project and frustrating me like crazy.

Cheers - Sarah