How do I save the amount and not the id in my database?

pasbonte · Post by **pasbonte** » 2023-11-08 18:16

Good evening

I have a database that works well, the staff enter hours by choosing in a combo field, but the value is always recorded with the id and not with the number, the amount. How do I save the amount and not the id in my database?

How do I save the amount and not the id in my database?

I'm attaching copies to be clearer,

thank you
formulaire

: Capture d'Ã©cran 2023-11-08 191137.png (27.81 KiB) Viewed 2305 times

mysql

: Capture d'Ã©cran 2023-11-08 191226.png (64.48 KiB) Viewed 2305 times

: Capture d'Ã©cran 2023-11-08 191415.png (44.63 KiB) Viewed 2305 times

jsetzer · Post by **jsetzer** » 2023-11-08 18:42

That's the way lookups work. They store the primary key of the chosen record.

Consider adding another field and configure it as calculated field. The SQL command should fetch the value from the 2nd table where table2.pk=table1.fk

pbottcher · Post by **pbottcher** » 2023-11-09 22:14

Hi pasbonte,

maybe you explain a bit more what you try to acheive and why you need to store that data in the same table. That could help in finding a solution.

baudwalker · Post by **baudwalker** » 2023-11-09 23:17

Hi pasbonte,

Have a look at this.

viewtopic.php?f=6&t=2618

Barry

AppGini Community Forums

How do I save the amount and not the id in my database?

How do I save the amount and not the id in my database?

Re: How do I save the amount and not the id in my database?

Re: How do I save the amount and not the id in my database?

Re: How do I save the amount and not the id in my database?