Understanding relationships

This support ticket is created 5 years, 10 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Kolkata (GMT+05:30)

Tagged: Post-relationship

This topic contains 1 reply, has 2 voices.

Last updated by Minesh 5 years, 10 months ago.

Assisted by: Minesh.

Author

Posts

April 30, 2019 at 12:34 pm #1237744

grahamG

In my past I designed SQL databases. When creating relationships between tables you always had to define a common key field. In toolset you select two CPT to connect and I presume this is creating a relationship between their database tables. What determines the connecting fields between the two and can that be changed?

April 30, 2019 at 1:03 pm #1237752

Minesh

Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

Well - Toolset stores the relationship content using custom Tables added to the database.

I would suggest you to check your database and chech the following tables and try to understand the structure.
=> toolset_associations
=> toolset_relationships
=> toolset_type_sets

What determines the connecting fields between the two and can that be changed?
=> Relationship is actually setup between two post IDs, you can obviously Disconnect it using GUI.

Please check the following Doc:
=> https://toolset.com/documentation/post-relationships/how-to-set-up-post-relationships-using-toolset/#how-to-connect-related-posts