Is there any possibility to recall a value of a column in a parent table to a virtual column in a child table? For example, my app has a table called “personal details” which behaves as the parent table, and in it there are multiple child tables referenced to it, one of which is “management” table. I would like to create a virtual column inside the management table that will be able to recall the name type column called “First name” in the “personal details” table (which is the parent table). Is this fundamentally possible?
Since it is possible to recall a value of a column in a child table to a virtual column in the parent table using the expresssion,
INDEX(SELECT([List type column for the referred table][specific column name that I want to recall from the referred table],TRUE),1),
I was wondering whether it’s possible to do the opposite.
Thank you for your help.