I have 2 tables which are Table A and Table B.
Table A consists of these column: [Name], [ID](Key & Label), [Age]
Table B consists of these column: [Unique ID](Key & Label), [Name], [ID], [Task]
I have connected 2 tables with [ID] column and i have turned on “Is part of”.
These are the formula i used in table B.
[Unique ID]= UNIQUEID()
[ID] = reference to Table A
[Name] = [ID].[Name].
[Task] = no formula.
Here comes the problem.
When i fill in [Name], [ID], [Age] in Table A, i will go to Table B to fill up the [Task]. Once i saved the new row i created, i will be back to Table A. Sometimes i notice i type in the wrong name, so i edit it. After i edit and click save(without going into child table), the [Name] in my Table B does not change. It still remain as the previous wrong name.
What can i do to make sure Table B has the same [Name] when i edited Table A only?