All,

I am having a very confusing problem. I have a parent table and two child tables. The parent controls the child tables using a programmatic assignment of SET RELATION TO. I have this combination in two different data session subclasses. The relations are set up correctly. When I do a SEEK() in the parent table in the 2nd datasession, the parent pointer moves, but the child record pointers do not move. If I have a browse window open for each of the three tables, when I select the parent table with the mouse, the child tables immediately re-synch to the correct record. Hence, the SET RELATION jumps in to life.

When issuing the seek() to move the pointer, the command is in a method of the subclass controlling the data session I am operating on, therefore, I am not trying to operate on data from a method in a different session subclass.

I have just upgraded to VFP6 SP4 as a result of a MSKB reported bug in the session class. This upgrade has not fixed the problem.

In summary, when using SET RELATION TO in my session class subclass, moving the parent record pointer does not trigger movement of the child table pointers. I would point out the the second data session subclass is instantiated from another data session subclass.

This app is going live on monday and I really am very confused about what is going on here. Any help would be much appreciated.