Set valuelist according to another valueslist in table view

How can I show, the correct display value for a document sub typ (2nd column) according to the document value (1st column), if the valuelist is filled at runtime?

For example, I have only set the document sub type (2nd column) for one record, but it is changed then for all records in the view.

[attachment=0]2014-01-24_13_18_47-Servoy_set_documentsubtype_valuelist_according_to_doctype.png[/attachment]

Hi Sebastian,

you can solve this by using the global method option to fill the value list.

be aware, this can be an expensive job as you’re working in a list here.
but I guess there’s no real other option.

mboegem:
you can solve this by using the global method option to fill the value list.

be aware, this can be an expensive job as you’re working in a list here.
but I guess there’s no real other option.

Hey Marc, thanks for the hint. Do you think, it is better to store the values for the second column in a table and then fill the field by a relation?

I now fill the complete valuelist for that field, but now I ran in another problem. I want to change the second column according to the selected first column value, but the “onDataChange” method of that field is not triggered in find / search mode.

if they are stored in a table you can use a relation in your value list to get them.

otherwise using a global method is the only way to do it.

I believe the latter support find/search mode as well.
Although I’m not 100% sure on this.
Just give it a try, putting together a rough outline for the method will be like a 5 minute job, then you can determine if this is gonna work.