Hello,

Let's say that I have a 3 schools in a city. Of course, each school
has many students. I know how to use portals and whatnot, but is
there a way to capture the one-to-many relationship in a single
Calculation field? For argument's sake, let's just, for formatting
reasons, say it is important that this be able to be done, not just
simply displaying portals the traditional way.

For example, here is what I would want the calc field to look like:

George Washington High
Jack Doe
Jill Doe
Thomas Jefferson High
Bill Smith
Ted Smith
John Adams High
Lewis Clark
Siegfried Roy

I was thinking a calc field in the "school" table that somehow
references the related records in the "students" table? This worked
for only one record (only one student showed up for each school).

HELP!!

Eric

In article <1180126520.956809.67110 (AT) q75g2000hsh (DOT) googlegroups.com>, EP
<ericp023 (AT) gmail (DOT) com> wrote:

When related fields are used outside of a portal you do only get the
first related record's data, although there are excpetions with some
functions and when acessing fields via a script which loops through a
portal's rows.

I'm not sure quite what you're trying to achieve, but the best place to
produce something like that is a printed reported from the related
table itself (Students?), using a relationship link back to the main
table if needed to retrieve any School information. That way a simple
layout using a Sub-summary section and sorted by School will give you
exactly that report.

If for some strange reason you do need a single field to "calculate"
that structure, then you will need to use a Global field and script
that loops through each records and an inner loop that goes through
record's portal rows.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Harry, The OP did not state version, but 8 has a brandspankingnew LIST
function. retrieving just what he needs.

list ( RelatedTable::Name )

Returns all related names to the current record as a list.

Keep well, Ursus