so here's our dilema. We have set up our facilities to only have two forms. An unsupervised climbing form and novice form. These are set up to both be 'waivers' e.i to tick the facility waiver box upon competition and both have the same document type.
With the above, is there a way we can filter these customers to find out all the customers who have either the unsupervised climbing form or the novice form.
The reason for this is we suspect we have customers with the Novice form who have subsequently been given a 'proficiency level' without having been required to fill out the unsupervised climbing form once gaining that proficiency.
We think we have explored all the 'customer queries' avenues so would this be possible with a paid SQL query? Perhaps by the title of the form?