>>> 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!!!

SET RELATION TO .... does not always work in grids.
I have verified it with Microsoft. They claim it is NOT a bug
but that grids are supposed to work with views.

With SET RELATION TO & grids, it could even work sometimes
and other times not. Microsoft was also able to reproduce this.

This is in VFP30 and I never tried to go back to RELATIONS
and grids since getting VFP50.

Gene Berger
Nationwide Warehouse
Columbus, Ohio USA