• Registered: 2014-10-04
  • Posts: 154

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

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Search by Contact name in two different Column!

Hello,

You can do it, using button with action "SQL query".


Please, download here example project:

Post's attachments

Attachment icon Employees search by one field.zip 5 kb, 935 downloads since 2014-10-27 

Dmitry.
  • Registered: 2014-10-04
  • Posts: 154

Re: Search by Contact name in two different Column!

Thanks a lot Dear Dimitri,
I've done it before! But I have a problem with names!
Contacts information's stored on another table! so I only store ID's on transaction tables!
and the problem is , Grid show ID's instead of names sad

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Search by Contact name in two different Column!

Please, send me your project to support@drive-software.com
I'll try to help you.

Dmitry.