I have 3 tabelles: Fussballer (footballer), Trainer (coaches), Verein (club).
I need a relationship between all tables. There can be multiple footballer to coaches, as well as several trainers to clubs and footballer to clubs and coaches to clubs and so on. Basically, all the relationships are n: m relationships. have I really invested this in Toolset, like to see at the screenshots? Or will the queries be presented about views . The sample pages always be go from 2 tables as a logical.
I visited this URL: https://toolset.com/documentation/user-guides/getting-started-views/part-9-many-many-relationships/
Creating 3-way many-to-many relationships is possible, but complex.
Firstly, you should be aware that there are major changes coming to Toolset relating to post relationships which will make this kind of thing far easier to set up and much more efficient.
You will be able to create relationships without the need to make intermediary post types (and in your example you will currently need to create intermediary post types for A -- B, A -- C, and B -- C).
There is no special handling required for connecting 3 CPTs. You will need an intermediate post type to join footballers to coaches, another to join footballers to clubs, and another to join footballers to clubs. You can set up your views etc as described in the linked documentation, but your data-entry to create all the intermediate posts is going to be somewhat tedious.
This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.