To Distinguish Last Name Fields on a Template I have the following Fields.
Last Name
Spouse Last Name
Birth Date
Spouse Birth Date
Is their an easy way to search both fields given the last name matched "Last Name" or "Spouse Last Name" similar to the Text Search which has operators available.
I realize I could use a multi-value field but their is no true way to distinguish or explicitly define which is the "Last Name" vs the "Spouse Last Name" other than the order perhaps the first value being "Last Name" and the second "Spouse Last Name". In fact this will apply to many fields on the Template like Birth Date etc.. so we have to assume and rely that all the 1st values are for one person and all the second values are for the second person which could easily be mistakenly interchanged.
I can write an Advanced Syntax to work and distribute via Attributes but not so user friendly for the end user.
In fact I may need to search something like the following:
If any of the Last Name Values Match and If any of the Birth Date Values Match and If any of the Driver License Numbers Match.