Not sure if I am going about this right but I am trying to create a picklist whose values are all values for another custom object.
Here is my setup.
I have a custom object called Courses which represents a number of courses that we offer. I also have a custom object named Group. Group is a group where a contact is assigned to. What I want is for a Group to have a multiselect list of Courses that a user or process could assign to a contact.
So for instance
Courses: Course A, Course B, Course C
Groups: Group 1, Group 2, Group 3
Group 1 Courses: Course A, Course B Group 2 Courses: Course B, Course C
Joe Smith -> Group 1 Jill Misth -> Group 2
I will have a process that when a Contact is created or Updated and assigned to a particular group will go to the Group object, lookup the list of courses for that group and then assign the Course to the Contact.
Is this possible or am I going about this all wrong?