Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids 1:M problem
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00093601
Message ID:
00093943
Views:
28
>>>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

You also need to make sure that you are in the child grids workarea. You might need to select that workarea upon entry of a form or a page on a pageframe.

Steve
Previous
Reply
Map
View

Click here to load this message in the networking platform