AnsweredAssumed Answered

Restricting a find request

Question asked by NigelBurton on Oct 14, 2014
Latest reply on Oct 15, 2014 by NigelBurton


Restricting a find request


I am working with an Order table that has Order_Number as the main field for searching but also a sub number field as well. The order number is generally always a numeric value, i.e 19704 but occasionally the order number will have to be say 19704A.

When I do a search to list all orders with the order number of 19704A I also get all orders with the number 19704.

How do I set it so that I will only get the orders that relate to main order 19704A.

Any assistance would be appreciated