Note: I miscategorized this post and cannot switch it. Should be in Behaviour: How to?
I have two tables:
- Student Info 2. Student Timetables
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.