>>>Hi,
>>>
>>>I have a table with blank fields which I would like to reorganize. see picture enclosed (one picture says more than 100 words)
>>>Also enclosed a test,dbf 'table1
>>>Is there an SQL statement to do this, or should I rely on a scan ... endscan statement?
>>>Regards,
>>>Koen
>>
>>What happens to Ids?
>HI,
>
>The ID in the resulting table should be a new distincst ID, if possible. (if not, can always adjust that field on the end)
>Regards,
>Koen