List Names field

[vierdewereld]

Can't seem to solve this calculation, perhaps because it is 4am but. It would be great if I have this solved when I start after my rest.

It's quite simple...

I have the fields: UniqueID, IDlist, Namefield

What I would like is to have all the UniqueID in a list replaced by the Name field content.

1. I have a list of UniqueID's in the field IDlist

tekst field IDlist:

ABCDEF

FIJEJFIE

WERLTJ

FWOIWE

2. These ID's refer to the tekst field UniqueID.

3. I can make a relationship IDlist::UniqueID called IDdisplay

and use this in a calculation field, but this will only show the Namefield once.

I need to have a calculation that replaces every UniqueID in IDlist with the Namefield it refers to.

Is this possible & how?

[vierdewereld]

Some good sleep really helps..

By using a Value List with the relationship IDdisplay was all that I needed.

Then use the ValueList(Status(CurrentFile), "NameofValueList") in the calculation field.

Simple as that.