> > >> > >> 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 The only thing I can suggest right off the bat is check your datasessionIDs. Make sure each form is using the same datasession. Also, is it necessary to use separate forms? What about PageFrames? HTH Matt -- Matt McDonnell