Summary field from a relationship

[amemme]

Hi,

I need to set up a summary field that will collect all of the information from a specific field for all records using defined in the relationship. This field need to omit any repeating values.

For example:

If I have three records that pertain to a certain relationship. In each record there is a field that describes the colour of the product as follows:

Record 1 colour: red

Record 2 colour: blue

Record 3 colour: blue

I want to have a field that will sumarrize the colours to be use for this project as:

Colours to be used: red, blue

Any suggestion will be greatly appreciated.

Thnak you,

Anthony

[BobWeaver]

Make a value list based on the field you want to summarize, then use the ValueListItems function to get the summary.