>>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
>
>Filters are slow.....parameterized views would probably be faster. Are you using the .ChildOrder, .LinkMaster and .RelationalExpr properties in your child grid? If not, look into them, they should do what you want.
>
>Steve
Yes I'm using all of these. Works fine so long as the view has data. I'll try parameters.
Thanks - Sarah
Sarah King
pcpropertymanager.com