Hi all first post for me. I am using FM to get records via a relationship to a number field. It works well with numbers but if the entry is numbers and letters it then chooses the number and displays this.
e.g If I put in 121 it gets the records for 121 fine but if I enter ad121c it then gets 121 records. How do I exclude those entries with a combination of text as well as numbers.