>>
>> Hi All,
>>
>> Here's my problems, I'm opening about 4 database that each has it own
>> filter. The 4th one has 3 relations (with the DB opened). My problem is,
>> when I do all the command in the "command window", I get the result I want
>> but when I try through my application and try to the result in a grid, it
>> looks like it is NOT doing the relations!!!
>>
>> Any idea?
>>
>> Yves
>
>I'm not sure I follow. Are you doing a SQL, or are you just browsing a
>parent and looking at the children?
>
>Is this how you're set up?:
>TableA
>| | |
>| | |-----Relation1---->TableB
>| |------Relation2---->TableC
>|-------Relation3---->TableD
>
>What works in the command window and not in the code?
>
>I think you'll get a better answer with a little clearer info.
>--
>Matt McDonnell


Hi Matt,

Thanks for replying, so far no SQL statement is involve as I try to re-use every possible code I can (converting from FP DOS2.5 to VFP5.0)! In command window, opening a database, setting the order, setting a filter and setting relations on the last table. Than when I browse the window with the relations, I see the result I want to get. When I put the exact same code in my form (in a formset) and try to call the second form, which show only the grid to display those records found by the relations and filters, I get to see all records, like if the filters and relations didn't work! You had a pretty good idea on the table with relation looks like. I hope this time I was more helpful.

Yves