>>Because I have been having difficulty getting the SELECT *; Inner Joins
>>to work in one SELECT statement, I have had to resort to the following
>>code. It works and merges all the tables correctly in Cursor3. I
>>cannot get VFP 5.0 to remove the 'ourdata' table. It produces an error
>>message 'Cannot access the cursor' when it reaches line 5, the REMOVE
>>TABLE ourdata DELETE statement. If I can remove ourdata, then the INTO
>>clause of the last SELECT will work. Any ideas? Thanks. I cannot
>>get at the Universal Thread mail messages today. The Internet must be
>>very busy. dowe@itsnet.com. Don West.
>>------------------------------------------------
>>THISFORM.Check9.value = 0
>>CLOSE DATABASES
>>OPEN DATABASE ims SHARED
>>USE ourdata
>>REMOVE TABLE ourdata DELETE
>>SELECT *;
>> FROM ims!examdata LEFT OUTER JOIN ims!classes ;
>> ON examdata.classid = classes.classid ;
>> INTO CURSOR cursor1
>>SELECT *;
>> FROM cursor1 INNER JOIN ims!students ;
>> ON cursor1.studentid = students.studentid ;
>> INTO CURSOR cursor2
>>SELECT *;
>> FROM cursor2 INNER JOIN ims!instructor ;
>> ON cursor2.instid = instructor.instid ;
>> INTO CURSOR cursor3
>>SELECT *;
>> FROM cursor3 INTO TABLE ourdata
>>BROWSE
>>*goApp.DoReport("reports\ourdata.frx")
>
>How does ourdata get added to the DBC? remove won't work unless it's in there...

I originally added it manually with the New table without any data. I also included it in the project. So I know it's out there. I have browsed it.