Ashley,

make sure that cpdbf() and cpcurrent() shows the same value for all involved tables.

>Hi,
>
>I've recently encountered a baffling issue, and would appreciate it if anyone has a explanation.
>First, I'm using VFP9 in my development environment, but the production environment uses VFP7.
>The start program is an exe compiled with VFP7 and the rest of the sub programs are FXPs.
>
>One new report uses a table related by Employee ID to another table.
>For some strange reason, under VFP7 the relationship is not correctly moving the pointer for the second table as in:
>
>USE TableOne ORDER empid shared
>USE TableTwo ORDER empid shared in 0
>SET RELATION TO empid INTO TableTwo
>
>TableOne empid is one value, tableTwo empid is not the same under VFP7, but works fine under VFP9.
>This is causing the report to yield 100's or records under VFP7 and 10's of thousands of records (correctly) under VFP9.
>
>I reindexed the tables - no luck.
>I did notice that the problem was was with 2 sites, but not the third where it worked just fine (all under VFP7)
>
>I have kludged it to work with a:
>=seek(TableOne.empid,'TableTwo','empid')
>
>...but this is fundamental and I'd like to know what I've done wrong...
>
>TIA