Be able to conditionally query on a Constituency
Because a constituent record can have more than one active Constituency at once, you canƒ??t just use the ƒ??One ofƒ? qualifier in query and select a list of values when applying a condition to the Constituency field. You need to select each of them individually one after the other and create separate condition statements for each value. Itƒ??s painstaking and not necessarily convenient, efficient, or user-friendly.