I have a portal with instructors names. I need to have a global field for a report that can list all the instructors.
Works fine with one instructor, but how do I pull the contents of portal row 1, 2, and 3 if there is more than one instructor?
thanks.
The List() function is excellent for this, as it also works on a related field:
Any given List() will be only those related records to the parent.
If you need more than one field, I've used a calculation field (in child) that I can "list" in the parent. For example a list of related addresses with city (two fields).
Beverly
List ( PortalTableNameHere::InstructorName )
Will produce a list of names with returns separating each name. You can use substitute to replace the returns with other characters such as commas.
And ExecuteSQL can do the same, but with options that can sort the data into a specific order and/or use a WHERE clause to only list records matching specific criteria.