First value double / second not - but only showing 1 possibility

[chapeau_melon]

Is there a work around for this

Valuelist showing as well as field 1 / field 2

example :

100 aaa

100 bbb

When selecting in a dropdown I get only 1 possibility to choose: 100 aaa

Kind regards

[mr_vodka]

If you are sorting it by the first field, which in this case you are, it will only display the first instances of duplicate values in the sorted order. Value lists normally only display a value only once. If this was sorted by the second field, then you would see both.

However, that may not be feasible in which case you may have to go with either a concatanated field of fields 1 & 2 or you could use a popup window to allow your users to choose from that list instead or FM's value list.

[chapeau_melon]

Simple but effective. I just make a suplementary column with the concatenate of the others.

Thanks for the suggestion

Kind regards

[chapeau_melon]

Ok but I have one small problem:

The fields were :

number text1 text2

100 AAA BBB

100 CCC DDD

The value list was show in field 'number'.

So after choosing, the number was correctly filled in the 'number' field

And via a calculation, the corresponding values were set in the fields 'text1' and 'text2'.

I do not have space to create an extra field in the layout for the concenate.

So suppose I use the concenate as value list in field 'number'.

But how do I have to do to show in field 'number' again only the corresponding number ?

Can I use the calc methode as for the other fields?