I am getting an error in a field that I'm sure has worked OK in the past. Please can you help spot the problem?
In a certain form I have a computed text field with the formula @If(Consequence_People="Cat 8";@DbLookup("";"";"Default settings";"Safety risk matrix";"Cat8_Inj_Onsite"); and several more similar conditions. It also has a field "Consequence_People" which is a radio button field with values "Cat 8" and other key values.
In the view "Default settings", I have a number of forms, one of which is "Safety risk matrix". In this view there is only one form of this name, and it contains a text field "Cat8_Inj_Onsite" (and others for the other conditions) into which I've entered words. I expect to see these words in the computed field when selecting
Selecting any of the radio button conditions brings up "ERROR: Entry not found in index or view's index not built" in the computed field.
I have made a full index of the database and if I click "View Search" I see "Indexed" on the top line for all views, so I think it's indexed, unless there's more than one index type.
There are several similar lookup systems in the form, and they all bring up this error.