Page 1 of 1

SQL...

Posted: 2023-09-06 14:49
by pasbonte
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 4627 times

Re: SQL...

Posted: 2023-09-06 14:54
by pasbonte
AUTOFILL !!!!

Re: SQL...

Posted: 2023-09-06 15:01
by pasbonte
WHY NOT SUM ?
Capture d'écran 2023-09-06 165957.png
Capture d'écran 2023-09-06 165957.png (148.31 KiB) Viewed 4625 times
Capture d’écran 2023-09-06 170225.png
Capture d’écran 2023-09-06 170225.png (22.72 KiB) Viewed 4625 times

Re: SQL...

Posted: 2023-09-07 07:58
by onoehring
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