Borislav

The cursor has been created using:

SET TALK ON
SELECT modacad.mainkey as mainkey, planning.planextra4 as group, planning.planextra1 as element, planning.planextra3 as weight ;
FROM "U:\Questpdm\Data\modacad.dbf", "U:\Questpdm\Data\planning.dbf" ;
WHERE modacad.mainkey=planning.mainkey and modacad.mainkey="T56*SS2004*NEIL001*SAMPLE" ;
AND planning.lev1=1 ;
INTO CURSOR fablinsty
SET TALK OFF

Then I need to copy those records into a new cursor. I could SQL to a cursor but I need to do the same thing again with another table. Basically I have 2 seperate tables and I want all of the records from both tables into a new table. Therefore I thought I would copy the records from both tables into my newly created cursor.

I have tried the following:

CREATE CURSOR crsrisk ;
 (Mainkey c(30), Group C(30), Element C(30), Weight C(10))

APPEND FROM fablinsty FIELDS mainkey, group, element, weight

This causes a problem in that when I run this it is saying that it cannot find fablinsty.

Any ideas?