summary list of child records

[Aussie John]

Hi

Im struggling to show a summarised list of a particular field of a child in the parent.

eg parent record relates to a list of rooms (child). Each room is in a building and Id like to see a list of buildings in the parent.

Child records

room1 is in building A

room 2 is in building A

room 3 is in building B

room 4 is in building B

room 5 is in building A

In the parent I'd like to see a field with just "A¶B"

It also needs to be indexed so I can use it in a relationship.

thanks

[comment]

I am not sure what the parent table here is - probably not Buildings. Do you also have a table of Buildings?

It also needs to be indexed so I can use it in a relationship.

This cannot be indexed, since it references related fields. Please explain what relationship you want to base on this.

Edited March 7, 2011 by comment

[Aussie John]

I am not sure what the parent table here is - probably not Buildings. Do you also have a table of Buildings?

This cannot be indexed, since it references related fields. Please explain what relationship you want to base on this.

Hi

There is no building table. The parent is a generic room type. eg "office"

I want to track queries and revisions to items in the generic room type and be able to separate them by building.

[comment]

There is no building table.

Perhaps you should consider having one, since then a simple:

List ( Buildings::BuildingID )

would provide the list you want. Without this table, you could either settle for a list with duplicate values:

List ( Rooms::Building )

or use ValueListItems() - either to filter the list above, or to produce the list (by using related values only).

I want to track queries and revisions to items in the generic room type and be able to separate them by building.

I am afraid you've lost me there.

[Aussie John]

Hi

There is no building table. The parent is a generic room type. eg "office"

I want to track queries and revisions to items in the generic room type and be able to separate them by building.

thanks