I have two filters for my quote list form:-
- Status
- Raised By
I would like to introduce a third "Quote No." When the checkbox is used to filter the Status for e.g. "Lost" only records with the value of "Lost" are displayed, however, I need to a way to filter the list according to it's quote number. I have a revision system in place which increments the revision with a letter after the quote no. Ideally I am trying to ask if it's possible for a box to allow me to type "1048" for e.g. which would return two records only, 1) "1048a" and 2) "1048".