>I strongly recommend you use a view. This makes updating quite easy: save data with TableUpdate(), und changes with TableRevert().
>
>For indexing, you can either 1) create indices in the local disk, for instance, in the folder getenv("windir") + "\temp", 2) create index names with function sys(2015).
>
>Hilmar.

Hi, Hilmar

In creating tmp file I'm using CREATE CURSOR tmp file so that if I close all the app. , the tmp file would be deleted, I've never use a VIEW before, could you tell me how make it.

The index way you gave me worked fine, thanks.

regards,

Budianto