- Place a virtual column in parent table. App formula simply uniqueid() – [unique]
- On the child table, create virtual column to pull the parent record of virtual column, using deref such as [parent].[unique]
Assuming the both virtual column value returns the same value as it is REF, looking up the value in parent table. However, it seems the uniqueid expression is separetely excuted on parent/child table, regardless of the actual expression I placed for.
Interestingly, the child table multiple records which ref to one parent. Those child table virtual column is returning the same values.
Shall I go to support to call for a bug fix, or this is native and expected behavior, so no point to correct?