>Hello:
>
>I am setting up relations within a transaction. The code executed is:
> SELECT primpdat
> SET RELATION TO lang_Pref INTO pkLabel ADDITIVE
> SET RELATION TO cheque_id INTO coll1 ADDITIVE
>This creates two relations properly with primpdat being the parent table ( Doing a ? set('relation') returns the two relations at this point).
>However when I try to execute (the next line):
> SET SKIP TO coll1
>I get the following error message:
>"Coll1 is not related to the current work area". All three cursors are in the same data session. Both relations are on numeric fields (I do not use an index here because indexes are not allowed within a transaction).
>
>What does this message mean, and how do I fix this so I have a 1 to many relationship?
>
>Thanks

This is not really an answer to your question but a helping point. When I need to deal with tables and relations and set skips, I would open my tables from the VFP command window, then enter the SET command to open up the data session window. I would then use it to set my relations. When you do this the code is generated for you in the command window. You can then use the copy and paste to put it in your programs/method/whatever or examine where your assumptions went wrong. Hope this helps.