Hi Devs
I would like to be able to add a column to a table and set that column value to be another value from a related table.
for example
if i have these tables:
-authors {objectId, auth_name}
-books {objectId, book_name, author(DOR)}
i can add a column in the table “books” with this value “authors.auth_name”.
the main reason for this is so we can use such values in the RT database mainly.
currently i have to do this manually and this could cause issues do to a human error if i forgot to update the value for example.