Can't Search in dependent fields
In my database I cannot search on those fields which contain values selected from pulldowns that contain values determined by the values in other fields. The error message tells me that the data can't be fetched, and to report the problem to Support.
The database is called RaPT-Sydney and I have granted access to Support so you can investigate the problem. The three fields which give the error are Unit, Strategy and Section. These three fields work normally in the Filter, and all other fields can be Searched as normal.
Can you explain why these particular fields give the error when Searched?
Can you suggest a solution?
Kevin