My Visual Database — Search by Contact name in two different Column!

Re: Search by Contact name in two different Column!

null@example.com (DriveSoft) — Mon, 27 Oct 2014 23:38:49 +0000

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

Re: Search by Contact name in two different Column!

null@example.com (sonixax) — Mon, 27 Oct 2014 22:56:20 +0000

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

Re: Search by Contact name in two different Column!

null@example.com (DriveSoft) — Mon, 27 Oct 2014 22:38:14 +0000

Hello,

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

Please, download here example project:

Search by Contact name in two different Column!

null@example.com (sonixax) — Mon, 27 Oct 2014 22:24:34 +0000

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