3 Replies Latest reply on Feb 23, 2012 2:02 PM by philmodjunk

    Searching across multiple fields



      Searching across multiple fields


      Hi all,

      I have a table that has records for 5 different "fathers".  So, there's a father1, father2, father3 etc, each with a first and last name.  When attempting to perform a find on a father's last name, I would need to input the same "Smith" into each of the last name fields to find said "Smith".  Is there a way to input "Smith" only once and search all last name fields simultaneously?

      Thanks, Emmett