>Hi Borislav
>
>>If you want something like record number out an identity field in the table and use it.
>
>Yup, something like that. Actually the records in the temptable need to have a serial no. of sorts, so that it can be used later as a PK (once pulled into VFP for further processing) till the temptable exists.
>
>Thanks for your response.
How you create Temp table?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.