We are using Opportunities to track class information for our school. We also track instructors as Contacts, and Opportunities have an Instructor lookup field that links the two.
We would like to create a form that maps to a Survey object. Ideally the Survey object will have a detail relationship to both Oportunity and Contact, and when we get a survey response it will create a new Survey record linked to both the Opportunity and its linked Contact, and visible in the related lists on both objects.
Is it possible to do this? Maybe by somehow passing the survey record ID twice to both the Contact and Opportunity?
Yes, create the survey object and map to the id to the contact and opportunity ... is there a reason why this wouldn't work with your Salesforce organization's setup?