Hello, new to Creator and just can't figure out what I'm sure is the most basic of requirements:
I have two forms:
Student
Class
Student form has a lookup field to Class as multi-select with Bidirectional Relation checked
Class form has lookup field to Student as multi-select with Bidirectional Relation checked
I can easily enroll a Student in multiple classes the issue comes with reporting
I need to run a report that shows the individual students enrolled in a class:
Class Name (3)
Student 1
Student 2
Student 3
All I keep getting is
Class Name (1)
Student 1, Student2, Student3
No matter what I do it's only one row, showing just 1 enrollment. I need to be able to view a student in its own row so we can "Enroll" a student in the classes they have selected and have an accurate count.
Very basic stuff and yet I've searched for hours on a solution having gone through every tutorial. Please assist, this is a paid account with expectations to roll out a basic student enrollment application within a week to hundreds of students.
Regards