I am trying to: create relational data model using Toolset: Games (G), Players (P), Teams(T). T one to many to P, T many to many to G, P many to many G (intermediate T - required, because not all P participating in G and P can change T)
Link to a page where the issue can be seen:
I expected to see: intermediate field as a type, T type for example, not a simple field. Then I can have a table with 3 ids - id_g, id_t, id_p and I can build view of all necessary protocols. Or I'd like to creat relationships between GP table and T table
Instead, intermidiary tables like GP not shown in relatioships wizard
Hi there,
Thank you for contacting us and I'll be happy to assist.
Your observation is correct and Toolset's post-relationship feature doesn't support creating relationships between "post types" and "intermediate post types".
To keep track of relationships between "Games-Players" and "Teams", you'll need custom code that makes use of "Post Relationships API":
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/
You can either store the IDs of all the relevant "Game-Players" intermediate posts, as a custom field value in the "Teams" posts or create and maintain a custom table ( ref: https://codex.wordpress.org/Creating_Tables_with_Plugins ) for storing all 3 IDs ( id_g, id_t, id_p ).
For a personalized assistance around custom programming, you can consider hiring a professional from our list of recommended contractors:
https://toolset.com/contractors/
I hope this helps.
regards,
Waqar
My issue is resolved now. Thank you!
