field in parent from child

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
guelland
Posts: 6
Joined: 2021-08-06 22:51

field in parent from child

Post by guelland » 2021-08-13 14:41

Hello, everyone.
is it possible to display a field from child in the parents?
Thank you very much for your support

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: field in parent from child

Post by jsetzer » 2021-08-13 15:22

Yes, for example by creating a calculated field in master table and using SQL to fetch any information from any other database table. You can use placeholder %ID% as primary key of master record in your SQL queries
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

guelland
Posts: 6
Joined: 2021-08-06 22:51

Re: field in parent from child

Post by guelland » 2021-08-13 17:36

Hello Jan,

I’ve tried so hard.
SELECT 'Nachname' FROM 'Spindbelegung' WHERE `Spindnummer`= '%ID%'

Unfortunately, this has not been successful. I’m sure you’ve seen that.
Could you help me with that?
Thank you in advance

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: field in parent from child

Post by jsetzer » 2021-08-13 18:00

Check the quotes surrounding Nachname and also Spindbelegung. Those should be backticks, not single quotes
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Post Reply