[Resolved] many to many with 3 tabelles

[Author]

Posts

[HenrykI1899]

Hello,
I am trying to:

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/

So how to do right?

[Nigel Supporter Languages: English (English ) Spanish (Español ) Timezone: Europe/London (GMT+01:00)]

Hi Henryk

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).

You can read more about it here: https://toolset.com/2016/08/how-post-relationship-replaces-post-reference-and-repeating-fields/

That work is ongoing and I don't have a release date for you, but if you can wait I would strong recommend you do.

If you cannot wait then you can go ahead and build your relationships as described here: https://toolset.com/documentation/user-guides/many-to-many-post-relationship/

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.