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
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