Hi, apologies if this is answered elsewhere in the documentation. I couldn’t find it in the generated column page or article, nor in prior posts.
Is it possible to have a Generated Column that uses a value from a field in other table where there is a 1:1 relation between the two tables?
For example: “TableA” has a field called “name”. “TableB” has a field called “address”. Could “TableB” have a generated field along the lines of CONCAT(TableA.name, address)? If the syntax is just wrong here could you suggest any other approaches to using a field from a related table in a generated column formula?