Values in related value lists

Classic Servoy
1

Hi all,

I made a valuelist based on related values.
In the M-+ Combobox M-; the values are shown, but duplicates are shown as well !
(several records have the same value and are shown serveral times in the value list)
How can I avoid this ?

Br
Stef

2

What is the value that you set in the end?
is that also the string you see? Or the id behind it?

Because if it is the ID then which string must be filterd out of the 2 values that are equal?

If it is the string. Why are there 2 string with the same value then in the first place?

Maybe we can filter dups out when the returned value is the same as displayed value. But i think this must be somekind of option.

3

Hi,

When I choose “All values from…” it’s OK, only UNIQUE values are shown.

With “Related Values” ALL VALUES are shown.

I think it’s a bug.

Best Reagrds,
Stef

4

Not a bug but not implemented (it is not that easy)

With all from table we can do a select distinct() when the return and display value is the same.

this is a bit harder to do when you select related.

We have it on our list to look at.

5

Great!

I’m looking forward. I’t really important for my solution.

Good luck,

Stef

6

Is fixed in the next build..

7

Hi All,

Another question about valuelists.
I want the valuelist to be editable by the user, like in FMP.
Also it would be nice to be able to put a separation line between
values: “-”

8

I want the valuelist to be editable by the user, like in FMP.

We intentionally didn’t add the “edit” option in pulldown lists, because we think valuelists shouldn’t be accessable to all users.
The easiest way to set up a maintainable valuelist mechanism is:

  1. create a table named “valuelists”
  2. create a column for each valuelist you need. eg: column “category”
  3. in the valuelist editor create a valuelist named “categories”.
    settings:
  • All values from table “valuelists”
  • show/return column “category”
    etc…
9

Just tested RC5, it works great!
Thanks a lot!

Best regards,

Stef