Page 1 of 1
field in parent from child
Posted: 2021-08-13 14:41
by guelland
Hello, everyone.
is it possible to display a field from child in the parents?
Thank you very much for your support
Re: field in parent from child
Posted: 2021-08-13 15:22
by jsetzer
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
Re: field in parent from child
Posted: 2021-08-13 17:36
by guelland
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
Re: field in parent from child
Posted: 2021-08-13 18:00
by jsetzer
Check the quotes surrounding Nachname and also Spindbelegung. Those should be backticks, not single quotes