Topic: Search by Contact name in two different Column!
Hi,
I have a project that is a simple accounting database!
one of my column called (From) and another one called (to) ,
so I can search them one bye one!
For example I add a record with the following information's :
From : User 1
To : User 2
Give : 10$
Get : 0$
and another record is :
From : User 2
To : User 1
Give : 10$
Get : 0$
I can search via search function between these records but only can find records from (FROM) or (TO) Field and cannot combine both of them in one query!
I need to have search query which when I Search User 1 Find any records that this user involved! (Both of them as Giver or getter)
How can I do that ?!
Thanks a lot