2 Replies Latest reply on Oct 15, 2014 3:02 PM by NigelBurton

    Restricting a find request



      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