>>
>> 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
Have you created a view for your grid?