Hi
Is it possible to use wildcard criteria based on a form field?
I am trying to ensure that users do not enter a new item into a table by entering a similar but slightly different description. For example, "Large Beef & Potato Pie" may already be in the table but I want to at least alert the user if they were to try and enter, say, '"Beef & Potato Pie Large" that a similar item already exists.
Ideally, I would like to display a list of similar items as the user enters the data with the list reducing as each character is entered. For example, if the user types "Lar" the list will display all items with those characters contained in items in the table but as the user types further, say, "Large" it will only display those items from the table that contain the word "Large", etc.
It is important that the criteria searches in all parts of the current table field, not just starting with certain letters.
I hope I have explained this clearly. I know what I am trying to achieve but am struggling to put that in writing!
Many thanks
Is it possible to use wildcard criteria based on a form field?
I am trying to ensure that users do not enter a new item into a table by entering a similar but slightly different description. For example, "Large Beef & Potato Pie" may already be in the table but I want to at least alert the user if they were to try and enter, say, '"Beef & Potato Pie Large" that a similar item already exists.
Ideally, I would like to display a list of similar items as the user enters the data with the list reducing as each character is entered. For example, if the user types "Lar" the list will display all items with those characters contained in items in the table but as the user types further, say, "Large" it will only display those items from the table that contain the word "Large", etc.
It is important that the criteria searches in all parts of the current table field, not just starting with certain letters.
I hope I have explained this clearly. I know what I am trying to achieve but am struggling to put that in writing!
Many thanks