Parent table and child table

Jin_Tan · 12-03-2019 11:53 PM

Hi,

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?

TyAlevizos

For [Table B].[Name], it should be “read only” and greyed out and always reflecting the reference.

I have built your app here: https://www.appsheet.com/samples/Sample-App?appGuidString=8f2fd6a7-c64f-4c1f-9181-79c4f97e017d

Is there something I missed? Or perhaps you did it differently on your end?

Jin_Tan

Hi,

Thank you for replying me.

As shown in the image above, when i changed the name in TableA from “a” to “b”, the name in the child table(TableB) does not change.

Koichi_Tsuji

Your reference between parent and child in this case is linked by ID column. I assume you made ID column in Child table as REF type, and reference table as parent.

If you want to change the Name column dynamically based on the entry into parent table, then

Make a virtual column in child table
for app formula in this vc, insert [ID].[Name]
Save changes in editor

By doing this, when you made change into Name column in Parent, it wont affect the relationship between parent and child, but the Name column in Child will be changed immediately after change in Parent. Try it out.

Jin_Tan

Thank you for your suggestion. It tested it and it did give me dynamic changes. However, it does not change the name in the database. I did try to set the formula in column [Name] = virtual subcon, but it does not change.

Jin_Tan

Anyway, Thank you everyone for your suggestions.

I have figured out a way by creating workflow rule to change the [Name] in the child table when the Parent table is added or edited.

Koichi_Tsuji

Glad to hear you find your own solution at the end.

abood89

Hi

Could you please share the way ?