No index for field error

[rogerte]

Can anyone help with this - if I had any hair left I would be pulling it out!

I have a table (FtNote.db) containing 3 fields
LANGUAGE A 2
FOOTNOTE A 3
FOOTDESC M 10

Language and Footnote make up the primary key.

However I keep getting an error "FtNote: No Index for fields FOOTNOTE" on the line I open the FtNote Table.

I have checked the Fields editor to ensure all 3 fields are present and listed correctly. I have also tried removing all 3 fields from the editor, but get the same error.

Can anyone suggest what might be causing the problem?

Thanks

Roger

 

[hilfy]

Have you verified the index to ensure that it is up-to-date and that both fields are indeed in it? You should be able to do this by going into Database Desktop.

-Dell

 

[rogerte]

hilfy

Have rebuilt and verified the table using Paradox 9.

Have no problems under Paradox.

Roger

 

[hilfy]

How are you setting the index? Since it's the primary index, I assume you're using the IndexFieldNames property. Have you tried opening it with the IndexFieldNames blank?

-Dell