Hi there all!

I have a db (one file), a value list (from field, so the field may contain duplicate values) and need to have the unique values for that field in a portal for further operations (i.e. finding). Example:

values in field: a, a, b, c, d, c, a ...

portal should show: a, b, c, d only!

Any suggestions for building the relationship(s) or solving that general problem?

Thanks in advance !!

Norbert

Hi, Norbert, and welcome to the Forums! Off the top of my head...

OK, I will assume you have a unique ID for each record -- let's call it IndexNum. Make a relationship from theField to theField and call that relationship RelOne. Now make a calc number field called UniqueValue: IndexNum = RelOne::IndexNum. This field will evaluate to the number 1 for exactly one instance of each value in theField.

Now make a calc number field that is always equal to 1 and create a relationship (named RelTwo) from this field to UniqueValue. Base a portal off of that and you should have what you're looking for.

I haven't tested this exact scheme, so it may need some tweaking, but it seems as if it should work.

HTH,

Jerry

Hi Jerry and thanks for answering!

I thought that it would work somehow like this and already tried a lot of things but the uniqueValue field cannot be indexed and the reverse relationship gives wrong values (see example) ...

Norbert

valuelistportal.zip

When will I learn to test?

Could you possibly script this? So UniqueValue is not a calc field but a straight number field, and its value is set by a Replace Contents step using the same calc as above.

J

Hi Jerry,

yes, that works as you described - thanks! But is there any possiblity to get it work without a script (this function should be triggered by another field) ?

Norbert