Referencing a name OR phone number?

[whostean]

Hello,

I currently have the ability to add a customer by name to a table using a searchable Ref.

Using the same column in the form view of the “member log,” I would also like to have the ability to search by the phone number associated with that customer, and have only their name appear on the table view of the log.

The source table already has CONCATENATE([First Name]," “,[Last Name],” ), so I tried changing to “CONCATENATE([First Name],” “,[Last Name],” [PHONE]) …without success.

Any suggestions would be greatly appreciated!!