it works but I can't run a REQUERY() on it. It give an error stating "function not allowed on native tables". Is there something else I can run on it?

>Should, but your ORDER BY is wrong. Remove the tempcursor. reference. It should be ORDER BY STOCKNUM
>
>>>The error means that TEMPCURSOR does not exist. Therefore, you can not USE it AGAIN.
>>>
>>
>>But judging from this:
>>
>>SELECT inventory.stocknum AS stocknum;
>>FROM Tomparco!inventory AS inv_this_trans;
>>INTO CURSOR tempcursor;
>>WHERE inv_this_trans.trans_id = trans_num; &&trans_num is a variable
>>ORDER BY tempcursor.stocknum
>>
>>Shouldn't it exist?