I am helping a local non-profit organization that does leadership training. They need to create a roster that will pull a list of contacts for the roster, and also store few topics that they worked on. There is a custom field in the contacts already that stores the class type and year. So far I created a custom object for Roster, with 3 fields for Roster name, Class Year and Class type. Now I need the roster to pull all contacts that have the same type and year in a list. Is there a way to have a custom field for a list of objects? Any suggestions on how should I approach this? I'm very new to SalesForce so any help is appreciated. Thanks!
Update: So I got it to work with the junction object and it's great! I can create a new Roster and pick Contacts with Lookup to add, one by one. My Sandbox is also ready. Now if I can get this the contacts to be added automatically, it would be perfect! There are about 100 contacts for each year, so doing it manually it is tedious/unreasonable. I've never written Apex code before so where do I start with the trigger? Thanks in advance!