Hi,
I run the following SQL, then when I browse I have spurious entry in record 1 of the cursor which contains the value from the last record in the table from the second select.
When I up or download arrow or click on a record the value follows the cursor, once the cursor moves on the field resets back to its original value, has anyone seen this, or what am I doing wrong.
Table1 & 2 are identical structure wise and table3 is the Master file for Table 1 & 2's F1 field.
I am trying to find all the entries that don't have a Table3 master file record, the client decided to do some editing thru the back door and broke all the links.
SELECT table1.f1 DISTINCT FROM table1 ;
WHERE NOT exist ;
(SELECT table1.f1 FROM table3 WHERE table3.f1 = table1.f1) ;
UNION ;
SELECT table2.f1 DISTINCT FROM table2 ;
WHERE NOT exist ;
(SELECT table2.f1 FROM table3 WHERE table3.f1 = table2.f1) ;
INTO CURSOR a NOFILTER
Thanks in advance
Regards N Mc Donald