Using Relational Tables to define a field.

[merlyn383]

I have 2 tables. one with student names and the team number that each student is on, another with an advisor's name and the team number that that faculty is advising. I created a relationship between the two so that i could create a portal from the advisor table to show all of the student's that are in a particular team. However, I want to be able to e-mail each advisor and include the full list of student's on each team. How can i define a single field that contains all of the student's names that correlate with each team #?

[-Queue-]

Create a value list based on the name field in students (using the student TO that applies to your team # relationship) and select the option to 'include only related values starting from' and select your advisor table. Then create an unstored calculation of ValueListItems( Get(FileName); "yourvaluelist" ). This field will then contain a return-delimited list of all students assigned to the professor's team.

[Ender]

Two possible ways:

1. Use a script to loop through the Student records, appending each name to a related field in Advisor (or a global.)

2. Define a value list (StudentNames) starting from Advisor, showing related Names from Student. Then define a calc in the Advisor table as ValueListItems( Get(FileName); "StudentNames" ).