SQL...

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
pasbonte
Veteran Member
Posts: 162
Joined: 2013-02-06 09:49

SQL...

Post by pasbonte » 2023-09-06 14:49

Bonjour

I have two tables one that is filled with the NAME and AMOUNT projects and another for entering money requests. I want us to be able to choose in the 2nd the NAME of the project and that the amount is displayed automatically. I search but I don't see, I tried SQL but it doesn't work. Thank you

In my example I want the value 50 and not both,
Capture d'écran 2023-09-06 164734.png
Capture d'écran 2023-09-06 164734.png (60.51 KiB) Viewed 2519 times

pasbonte
Veteran Member
Posts: 162
Joined: 2013-02-06 09:49

Re: SQL...

Post by pasbonte » 2023-09-06 14:54

AUTOFILL !!!!

pasbonte
Veteran Member
Posts: 162
Joined: 2013-02-06 09:49

Re: SQL...

Post by pasbonte » 2023-09-06 15:01

WHY NOT SUM ?
Capture d'écran 2023-09-06 165957.png
Capture d'écran 2023-09-06 165957.png (148.31 KiB) Viewed 2517 times
Capture d’écran 2023-09-06 170225.png
Capture d’écran 2023-09-06 170225.png (22.72 KiB) Viewed 2517 times
Attachments
Capture d'écran 2023-09-06 170106.png
Capture d'écran 2023-09-06 170106.png (175.51 KiB) Viewed 2517 times

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1167
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: SQL...

Post by onoehring » 2023-09-07 07:58

Hi,

I would think this is a bug. And you should post it in that subforum.
On the other hand, we can see, that it's a lookup and as this, the value shown could also be text. But: If you as the user decide to ask for the column sum, there shoule be one. As this: Bug?!

Olaf

Post Reply