Two One-to-many relationships pointing to the same table

Hi,

I’m just starting with Tap Forms, and it seems really awesome.
I’m building a database using some usual basic structures. Some of them rely on relationships like the one shown in this example:

Person (name, phone, [Roles in Projects]) one
                                                                      to many
                                                                                Role in a project ([Person], Role, notes, [Project])
                                                                      to many
Project (name, value, [Roles]) one

Such architecture is a simple way to link Persons and Projects with a many-to-many relationship, giving a particular quality (the Role) to each single relationship.

In this way, getting into the person Jimmy I can see that his role is Consultant for the project Abbey Grocery, and his role is Client for the project Green Campaign.
Getting into the project Abbey Grocery I can see there’s a role of Consultant played by Jimmy, and a role of Security played by Jack.

As you can see, one person can play many roles (each linked with only one project) and one project is linked to many roles (each linked to only one person).
In such basic db structure, which works flawlessly in mysql and access for example, the key is using one-to-many links on both sides. Using many-to-many on one or both sides would be misleading.

Maybe I’ve found the same issue in the forum, a thread of 2014 talking about mothers, fathers, and children. In 2014 a child had to have one only parent, or a potentially infinite number of parents. This because in Tap Forms a table couldn’t be linked by two tables in a one-to-many relationship: once set the mother, the father disappears and vice-versa.

I’m experimenting the same issue now, so I can’t translate to Tap Forms the architectures working in all the other database systems I work with, which would be really awesome. Please tell me if I’m missing something, or if this limit’s gonna be fixed, or if there’s an equivalent way I can use to set a table of exclusive links (like Roles) between two main tables (like Persons and Projects).

Thanks a lot.