Skip to main content

All users receiving error when trying to search clients for attribute

This article explains what to do if, when trying to search clients for attributes, all users are getting the error as below:

Written by Terence Cassidy
Updated this week

Failed to load data into the grid

Details: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, > >= or when the subquery is used as an expression."

Followed by:

An unhandled Exception has occured.

Details : Cannot find table 0.

at System.Data.DataTableCollection.get_Item(Int32 index)

........

This error usually occurs when a record has more than one attribute of the type Borough, as the search expects there only to ever by one and essentially breaks when there's more than one because it doesn't know which to use in the search results.

Please contact us via the MyAccess portal and include the full error and the title of this article.

Did this answer your question?