>>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
>
>Try to check if you still have the right Order Tag you had used in relating the parent and child. Because sometimes, due to long codes, we forgot to get back the right order tag to relate two tables.
>If you are using Child Order, Link Master properties, no need to use Filters, its toow slow.
>In fact, if connection is done on data environment, all is automatic on the form display area.

Thanks for your help everyone. As per usual with grids I muck around and do things which seem unrelated and suddenly, pow! they come right. I changed alot of things which I had resisted (like parameters) so some good came of it all. I appreciate your input.
- Sarah :)