Hi

No, I mean any table. We had exactly the same message, "Table has no index order set", even when there was not an index on the table. We got the message when chaging work areas!!!. Anyway, It was tracked down to the fact that a table was a recordsource for a grid, and was being updated with an SQL-select.

By setting the recordsource of the grid to '' or to '(none)', performing the SQL-select, and then reinstating the recordsource fixed the problem.

I would look for similar occurances of this in your form... even if it is not the permissions table that is being used as a recordsource.

>Mace
>
>Do you mean the PERMISSIONS table being used by a grid/combobox?
>
>Kev
>
>>Hi Kevin,
>>
>>I've noticed this strange behaviour when there are grids or combo boxes on the form. It normally happens because the recordsource or rowsource table is being modified or manipulated. If it is this in your case, you can try to set the rowsource or recordsource to an empty string, perform your calcs and the restore it.
>>
>>Best of luck,
>>
>>Mace
>>
>>>Hi
>>>
>>>I've had this problem for a while now, but it happens very rarely, and is impossible to simply replicate the problem.
>>>
>>>I have a seek that runs in my form class, but sometimes it will come up with an error of "Table has no index order set", here is the portion of code that it fails on, it's the SEEK that fails:
>>>

*Open PERMISSION table and locate Screen
>>>goCCMS.Used("Permissions")  && This opens the table btw
>>>
>>>*Obtain Permission settings for this screen and user
>>>IF SEEK(lcScreenId + STR(gu_Userlevel,1), "Permissions", "PERMISSION")
>>>     blah, blah.....etc.etc.
>>>ENDIF
>>>

>>>
>>>If I click Retry, it continues fine, like I said, it very rarely happens.
>>>
>>>Any suggestions.
>>>Thanks
>>>Kev