Wierd Problem with Grid

[KDavie]

I am experiencing a problem with a grid I use on a form. Although the parent and child table behind the form and its grid are related in the data-evironment, when the form is opened the grid displays ALL records in the table until the user navigates to a new record. At this point the grid recognizes the relation and only displays to related records. I am able to get around this by using a SET FILTER command in the init event of the form to filter the grids data-source for the correct records, but this seems unusual. Has anyone ever encountered such a problem or have any suggestions as to what the problem may be?

Thanks,

-Kevin

 

[DSummZZZ]

Try issuing a GO TOP or something to move the record pointer in the parent.
Relations are only updated when the parent table's record pointer is moved, so the child table has the potential to show all the records.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[KDavie]

Ahh... I was using GO TOP to move pointer in child, no wonder it wasn't working. I will try changing it now. Thanks!

-Kevin

 

[KDavie]

OK... I tried to issue go top on the parent record, but that doesn't work either. The only way I can get it to work is by using the FILTER on the child table and moving the record pointer. I guess I shouldn't complain since it is working. However, it still seems unusual that the relationship is set but is not being recognized until the user navigates to a new record. Oh-well, I suppose I will just stick with the filter.

-Kevin

 

[GriffMG]

Hi,

You have to update the GRID that controls the parent - not just the record - so refresh the grid that is linked to the parent table.

Regards

Griff
Keep [Smile]ing