Hi Geoff,

I don't know if it is an undocumented feature, but I do it often when verifying data that has been processed. I relate table1 and table2 on whatever common link fields, set filter to eof("table2"), set filter to not eof("table2"), set filter to table1.fieldx = somevalue etc. Normally only interactively when I am checking data in both tables in 2 browse windows to verify that related data was properly updated in both tables. I do not do this in runtime environment though because filters are very slow.

You can also create temporary indexes using fields from related tables in the index key. But you should not do this for a permanent index.

Elmer