I am a newbie and here is my situation. I am trying to add multiple contacts to an Enrollment Table that is related to both Companies and it related contacts.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
I have Company Table with a related Contacts table.  Separately, I have a Enrollments table that is related to both.  I would like to first select the Main Company.  Then I would like to add Contacts in that company as students.  Say I have 12 fields in my Enrollment table; Student1, Student2, ......Student12.  I would like to have each field reference the Company's contacts so that I can select and add them to the enrollment form.  Once the form is populated, I submit it as a single enrollment with multiple Students.  

I already have it built so Student 1 is a conditionally drop-down of the related company.



Thanks in advance
Photo of Nathan

Nathan

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QB_Support_Brian

QB_Support_Brian

  • 20 Points
Hi Nathan,



It sounds like you're off to a great start! I don't usually recommend creating multiple fields such as Student1, Student2, etc, to add multiple items of the same type on a single record. In your case, that would limit you to how many students can be added per record. The best thing to do would be to go to Help > Manage Support Cases > + New Support Case so a customer care specialist can review your setup with you. The way these kinds of table-to-table connections are best set up really depends on what kind of data you're working with.




Thanks,

Brian