I have posts of two different categories that I can't easily relate. categories are: instructors and class categories (like aerobic, weights etc.) I would like to tie instructors to class posts NOT class types.
Ideally from the post edit screen, I would like a dropdown of all instructors available from the class postings and then be able to select an instructor.
Here is the class listing page http://howlingwolfmedia.com/site3/classes/classlist/ You can also see the instructor's listed under > classes > instructors I'd like the selected name to then show in the 'instructor' column.
code for the classlist table: http://pastebin.com/tNScDVxW
class postings fall under child cat 5-10 of parent cat id: 4 instructors cat id: 4 these are standard (not custom) post types
This must in some way alter the admin part of the site and I'm not familiar with coding for that... nor am I well versed in mysql coding etc.