Function to combine text field from multiple records

[PeteW]

I would like to calculate a text field that would compile a list of "Names" with "Mode" = enabled:

Fields

Name

Mode

Calculation Text

-----------------

For example,

Record 1 Name = Fred Mode = Enabled

Record 2 Name = Jim Mode = Enabled

Record 3 Name = Mary Mode = Disabled

Calculation text would be Fred, Jim

Any advice or assistance is greatly appreciated, thanks in advance !

Edited April 21, 2010 by Guest

[TheTominator]

One way to do it is to

Create a calculated field that returns a Text value

cConst_Enabled = "Enabled"

Uncheck the box for "Do not evaluate if all referenced fields are empty"

Create a new Table Occurrence of this table "TableName__Enabled"

In the Relationships diagram connect "cConst_Enabled" in your original Table Occurrence to Mode in the "TableName__Enabled" table occurrence.

Create a calculation in your original table

cListEnabledNames =

Substitute(List(TableName__Enabled::Name); "¶"; ",")

[PeteW]

You ROCK, that did it, thanks so much....... gracias, merci ....