>>I get a syntax error when attempting to set the filter for the child table in a grid on a 1 many form.
>>
>>thisform.dataenvironment.cursor2.filter = task.startdate = ld_date
>>
>>Does anyone see what could be wrong with the above line?
>
>Evan, first put your filter in quotes
>
>thisform.dataenvironment.cursor2.filter = "task.startdate = ld_date"
>
>Second, be sure that ld_date will be visible whereever you use the filter. (If you set it in a method, it may go out of focus.)
>
>Finally, try using the grid properties (LinkMaster, ChildOrder, etc.) to show the correct records instead of a filter.
>
Barbara,

Okay... 1 worked, 2 worked but I am puzzled about 3.
Linkmaster is akin to the old "set relation", and Childorder is similar to "set order" so I don't get how this will help me. (Which is perhaps not all that suprizing). :-)

Normally I would have used a parameterized view to quickly and simply restrict the records displayed in the child table but I am trying out Visual Promatrix which doesn't support views well. This is why I have tried using a filter. I have avoided filters up until this point.

If you have time, could you explain the method you mentioned above?