Jump to content

summary list of child records


Aussie John
 Share

This topic is 4345 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4345 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.