display selected values from a value list

[Stephen S]

How does one display selected (more than one) values from a value list with more than two values in the list.

I have a school PTA database (one table) with all student names and their parents. To join the PTA, I created a value list listing - student ; parent1; parent2 with check boxes next to each. Sometimes all 3 joined; sometimes 2 or just one.

In trying to display actual names from the choices I created a field for each to display each selection which works fine except when 2 check boxes appear in the record and nothing is displayed

Case(PTSA_Membership="Student1";Student) I realise Case only outputs one result.

Stephen

[sbg2]

When selecting from a checkbox set the selcted values are stored in a return delimited fashion. If student Amy Anderson and her mother Angela are both checked the field would contain:

Amy Anderson

Angela Anderson

I have attached a file to demonstrate a few ways the choices can be dislayed.

CheckBoxList.zip

[Stephen S]

Very cool. I'll figure out all the reasoning, especially the need for Student and Student 2 in the graph .

The PTSA thanks you

[sbg2]

The reason for adding Student 2 to the graph is to limit the choices in the PTSA_Membership field to only those related to each particular student. If you dont add the second occurrence of the Student table to the graph then the PTSA_Membership field would show every single student (and both parents) in the table as choices. I have Attached a file that demonstrates this.

Think of adding the second Student table occurrence (Student2) as creating a copy of the Student table but the copy only contains records that match the currently displayed student record in the first table occurence. Hence the ID_Student = ID_Student relationship. So when you are viewing Sally Silly's student record in the Student table the Student2 table would only contain Sally Silly's record. If you went to Tommy Terrible's record in the first table the second table would only contain Tommy T's record... and so on. So by using the Student2 table occurrence to create the PTSA_MChoices Value List you limit the choices to only the currently selected student (in the first occurence of the Student table) and their parents.

CheckBoxList2.zip