Hello, everyone.
is it possible to display a field from child in the parents?
Thank you very much for your support
field in parent from child
Re: field in parent from child
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
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<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 readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: field in parent from child
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
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
Re: field in parent from child
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
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<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 readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools