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

Topic: Get Bilance from inputs!

Hi,
I have a database that set records about get and give money!
So I can search by input user and get any record that user involved!
So,
I have two column on my database :

Give
Get

In my example in a record Person 1 give 1$ to person 2
and in another record Person 2 give 2$ to person 1.

so, when I want to get a Bilance from Person 1 and sum all of amounts , I can show all of transactions in grid ! but logically  when person 1 give something to person 2 it means Person 2 get it from person 1 !!! (Hope you understand me)

and this is make a problem with my project sad
Because when I get a billance from Person 1 , and show person 2 in my grid (because person 2 involved in) , all amounts person 2 give to person 1 and person one give to person 2 show in one column! While, when I search Person 1, Person two gives must be shown in GET column! and person 2 gets must be shown in Give columns!
We have the same thing about Person 2!!!

so I need to know how can I do that ?!

Please see the picture for more information's.
Thanks a lot

Post's attachments

Attachment icon person 1.png 87.81 kb, 360 downloads since 2014-11-04 

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

Re: Get Bilance from inputs!

and pics for person 2

Post's attachments

Attachment icon person 2.png 79.44 kb, 358 downloads since 2014-11-04 

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

Re: Get Bilance from inputs!

Please, send me your project to support@drive-software.com


Thanks )

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

Re: Get Bilance from inputs!

I sent project for you. Do you got it?

Dmitry.