Hi, I have an issue. I try to explain.
I Have 3 tables: Apoderados (parent table), Alumnos and Reitros.
The 2 child tables has the same structure and settings (Alumnos and Retiros)
And no further formulas.
The parent table has this structure
So, when I create a new record in Apoderado table, it show this view.
So, when I click in Add Alumnos, open a new window
Click Save and everything its ok
Then, I click in add Retiros Alumnos and I have to choose the Apoderados name, why the difference?
ANd then go to de data base, and show the "nombre apoderado" same as the RUT Apoderado, but the Label is Nombre APoderado in both tables.
Why this happen?
Solved! Go to Solution.
To be honest I do not know what is causing it.
Your REF_ROWS expression is definitely wrong. It has to be REF_ROWS("child table", "ref to parent column")
It certainly should behave differently if both have the same structures.
One thing I noticed it that the ref columns in the child table indicated here
do not seem to match your column definitions pictures, especially RETIROS ALUMNOS, which shows Nombre Apoderado as the intended Ref column. I do not know where you get this discrepancy in your pasted images but you at least need to resolve this.
HI, thanks for the answer.
You're right, for some reason it shows RUT.
I went to the VC Related Retiros and manually change the value to Nombre Apoderado.
It work (I don't have the dropdown list anymore).
Do you know why the ref take in one table the Nombre and in the other Rut column as a refference if I used the same exact setting on both?
ANd in the Apoderados form still shows different information
ANd, at last, in the Google Sheet DB, still shows Nombre y Rut with the same data
To be honest I do not know what is causing it.
Your REF_ROWS expression is definitely wrong. It has to be REF_ROWS("child table", "ref to parent column")
Currently AppSheet allows only one table at a time to have the "IsPartOf" relationship.
References between tables - AppSheet Help
I have a table that has two child tables and they work fine. I believe the document means a child table cannot have two parent tables defined.
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |