Title: Link Table?
Last modified: November 3, 2020

---

# Link Table?

 *  Resolved [craftylion](https://wordpress.org/support/users/cjmclean/)
 * (@cjmclean)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/link-table/)
 * I started this topic in a previous topic which seems to have been resolved yet
   I’m still confused as to how to achieve it.
 * I’ve been advised to use a link table. How do you create a link table exactly?
   The documentation on this particular subject is rather limiting …

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Jory Hogeveen](https://wordpress.org/support/users/keraweb/)
 * (@keraweb)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/link-table/#post-13619236)
 * Hi [@cjmclean](https://wordpress.org/support/users/cjmclean/)
 * For reference, link to the prev topic: [https://wordpress.org/support/topic/isolated-third-relationship/](https://wordpress.org/support/topic/isolated-third-relationship/)
 * I closed that topic since I mentioned anything there is to mention about a link-
   table.
 * See it like this.
 * A link-table is just a separate table solely for the relationships to be linked
   together.
    Let’s call the link a “Participant” for this example. So the participant
   would be a private Pod with only two relationship fields to the Actor and a Role.
   This could be an advanced content type with an actual separate table outside 
   the WordPress ecosystem. Since there is no other purpose for this Pod we don’t
   need to do anything else with it.
 * The Project Pod can now have one relationship field to the Participant Pod.
    
   With that link you’ll have a link to a combined relationship to an Actor AND 
   Role. You could even enhance the whole participant Pod with more data about this
   participant, like in your case, what seasons etc.
 * This is the only way to properly create a relationship like you want.
 * Keep in mind though, this is advanced usage of Pods and may require some experience
   with database structures to understand.
 * Cheers, Jory
    -  This reply was modified 5 years, 9 months ago by [Jory Hogeveen](https://wordpress.org/support/users/keraweb/).
 *  Thread Starter [craftylion](https://wordpress.org/support/users/cjmclean/)
 * (@cjmclean)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/link-table/#post-13619416)
 * Ah, I understand now!
 * Before I go, in order to achieve what I need in the frontend, how would I display
   this in the Project template? Also how would I link the Actor to the corrosponding
   pod post?
    -  This reply was modified 5 years, 9 months ago by [craftylion](https://wordpress.org/support/users/cjmclean/).
      Reason: Supporting request question
    -  This reply was modified 5 years, 9 months ago by [craftylion](https://wordpress.org/support/users/cjmclean/).
 *  Plugin Author [Jory Hogeveen](https://wordpress.org/support/users/keraweb/)
 * (@keraweb)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/link-table/#post-13624403)
 * Hi [@cjmclean](https://wordpress.org/support/users/cjmclean/)
 * Short magic tag example for Pod Templates:
 * A Project template:
 *     ```
       [each PARTICIPANT_REL_FIELD_NAME]
       Actor: {@ACTOR_REL_FIELD_NAME.any_actor_field}
       Role: {@ROLE_REL_FIELD_NAME.any_role_field}
       [each]
       ```
   
 * Please see this page and it’s introduction video’s for more info about how Pods
   works:
    [https://docs.pods.io/faqs/what-can-you-build-with-pods/](https://docs.pods.io/faqs/what-can-you-build-with-pods/)
 * If you want to go the PHP route you can use `WP_Query` and it’s meta query functionality
   to query for the relational data.
 * Cheers, Jory

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Link Table?’ is closed to new replies.

 * ![](https://ps.w.org/pods/assets/icon.svg?rev=3286397)
 * [Pods - Custom Content Types and Fields](https://wordpress.org/plugins/pods/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/pods/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/pods/)
 * [Active Topics](https://wordpress.org/support/plugin/pods/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pods/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pods/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Jory Hogeveen](https://wordpress.org/support/users/keraweb/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/link-table/#post-13624403)
 * Status: resolved