Can't get referenced column to appear in form

[Lovetosmile]

This is SUPER frustrating.

1. I have 2 tables - A & B.
2. A has the Original Key Called ID (text) and Column called [Patient journey].
3. Table B has the Same [ID] Key Column (but its ref), and a column called [TP Status].

All I want to do

1. When [TP Status] value is “Submitted” in Table B, I wan’t the [Patient Journey] to Change to [TP Submitted] in Table A.

What I tried

1. Creating Virtual Column in Table A for [TP Status] with Ref [ID].[TP Status]. But for some reason it will not compute the value. It won’t even appear in my Form.

This is frustrating because Table B has at lease 4 Ref Columns from Table A which serve the same function and work just fine. But when I try to go in revers, to Ref TABLE B columns in Table A, all of a sudden I can’t. Is it because Table B [ID] is a calculated value?

Please help