AnsweredAssumed Answered

Searching across multiple fields

Question asked by EmmettOliver on Feb 23, 2012
Latest reply on Feb 23, 2012 by philmodjunk


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