>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...