I’ve been playing with creating self-referential relationships, and it works well. Under the hood, I assume it uses a secondary table under the hood, which makes it very easy to create things like:
Friends People [many-to-many]
Followers People [many-to-many]
If you want to add a field to the relationship, such as a “Became Friends On” date, I’m curious if the relationship table is accessible? I’m not sure where the field would be visible–possibly as a virtual field on person.
Currently, I believe you would need to create the relationship table manually and create the rows manually. I tried this also, and it works, but the labels used in the rows are not as helpful (shows Parent or Friend, but not the person’s name).
A few notes along the way:
“Relation: Table name ‘Relation’ is invalid” – I assume it’s a db keyword or special name. It seems a bit awkward. Can table names be quoted/escaped?
Field name A is invalid – I assume it was just too short. Any reason for not allowing? I was just prototyping.
In the Data tab, how is the name/label for a row calculated? The first text field in the schema?