It's not going to work. Your temporary indexes will not be updated when master table changes.
>
>Probably missing something dumb, but...
>
>I have this screen with a grid whose table is related into a master employee look-up table.
>the table has a temporary index built to sort records by the look-up table's employee names.
>When I add records to the master table, they do not show until I back out and re-enter, forcing the temp index to be rebuilt.
>Out of desperation I've added redundant refreshes, set order to's, done a pageup/down - no luck..... :
>
>cPUNCH_CDX=TMP_DIR+sys(3)
>index on OWNER_ID tag EMPNO of &cSignInCDX
>index on EMPINFO.SNAME+EMPINFO.FNAME tag NAME of &cSignInCDX
>index on subs(EMPINFO.SIGN,2) tag SIGN of &cSignInCDX
>index on DUTY tag DUTY of &cSignInCDX
>set index to &cSignInCDX
>set order to NAME of &cSignInCDX
>
>any ideas, anyone?
>
>TIA
--sb--