Should I be using GetNth in this situation?

[HALBURN]

I am trying to create a calculation that gets all field values of a related record and combines them into a single field with a carriage return after each one.

I have tried to use the "GetNthRecord" function to achieve the desired result but I have to string a bunch of them together to get it to work.

GetNthRecord ( ASSIGNED_MENUS::MenuID ; 1 ) & "¶" &

GetNthRecord ( ASSIGNED_MENUS::MenuID ; 2 ) & "¶" &

GetNthRecord ( ASSIGNED_MENUS::MenuID ; 3 )

I am sure that this is not how I should be doing it. Is there a single function that can do this?

[aaa]

Hi, HALBURN!

Create condition value list by your relation, then use ValueListItems() function. I think must work.

[HALBURN]

I must be doing something wrong. I can not get the value list to show only the related values.

[aaa]

It will be better, if you attach here part of your file.

[HALBURN]

Here is a test file that I have created to illustrate the trouble that I am having with trying to get a related value list to work properly.

[aaa]

HALBURN!

I havn't .sit arcivator. Can you attach in zip format?

[HALBURN]

here it is zipped

RelatedValueList_v1a.zip

[Brian C]

Pulling related data into an unstored calculation field by using a custom function:

Custom Function: Concatenate

Parameters: field, start, number

Function Calc:

Case(start < number; getNthRecord(field; start)&" "&concatenate(field; start + 1; number);

start = number; getNthRecord(field; start)

)

All you would need to do is call the function in your unstored calculation field.

[HALBURN]

Thanks Brian, that worked great and I learned how to make a custom function.

I feel so Abby Normal :)