Difficulty with cross-object value template

Question

Hello everyone, 
 Could you please advice in creation of simple template for a column in Person table, where I'll use the value from ADSAccount table. 
 I have tried the following within CustomProperty10 column of Person table: 
 Value = $FK(UID_ADSAccount).ExtensionAttribute10$ 
 Value = $FK(UID_ADSAccount), ADSAccount. ExtensionAttribute10$ 
 Getting compile error. 
 Identity Manager v.9.1

Markus Weiss-Ehlers · Answer

When you look at the table definitions you will see that there is no foreign-key UID_ADSAccount in the Person table. The relations are the other way round, the table ADSAccount points to the person table via the FK UID_Person. That's why your template doesn't compile. 
 In general, if you want to copy data from a child table to the parent, you need to code this either in the on-saving script of the child table (ADSAccount in your case) which ends in a synchronous update of the assigned entry in the Person table, or you create a process chain for the events Update (and potentially Insert/Delete) depending on your use-case. For your special case, I would take a look at the default process for updating an identity (aka Person) with the data from an assigned ADSAccount. Check the documentation on that topic here support.oneidentity.com/.../18 HtH