I want the end-users to select a single Spot Check Code (A, B, C or D).
I then want to use that value in something similar to a LIKE statement to extract matching records from the external_choices tab. There are different combinations of A, B, C & D depending on inspection frequency for each feature, so an exact match does not work.
XLSForm currently looks like this:
In testing, I also noticed that using an OR operator returned no records...I expected that all records with a matching CP_System would have been returned.
Has anyone done something similar?