Hi folks
Note: I miscategorized this post and cannot switch it. Should be in Behaviour: How to?
I have two tables:
Each uses the student ID as the key field. I set student ID in Student Info table as a ref and pointed it to the Student Timetables. This relationship worked as expected.
However, if I set the student ID field in Student Timetables as a ref and point it to Student Info, I get an error about circular references.
How do I set the relationships such that opening either table first will provide a link to the other one? I have done this using Filemaker Pro in the past but cannot seem to make it work here.
Ok, so I have solved my own problem. Turns out AppSheet creates an automatic two-way link via a virtual column in the child table. For some reason the link wasnโt showing despite numerous syncs. Once I logged out of the phone app and logged back in the link appeared and all works according to my grand design.
Good, I was trying to think of the reasons that it wouldnโt show!
User | Count |
---|---|
16 | |
12 | |
5 | |
5 | |
5 |