Value List

Classic Servoy
1

Is it possible to have a value list that uses a relationship to display one field in a listing and return a diffent in the dataprovider. I wanted to avoid displaying the value that is in the list, and display the value in the data provider.

I guess what I am asking for is:
when you are defining your value list, under the definition portion you could seperate your Show in Field / List ~~ into two check boxes:
Show in Field
Show In List

Thanks, It’s not of great importance, but would be a nice feature.
Erich

2

Que?

Isn’t that the standard valuelist feature? Those comboboxes you would like, aren’t they allready there?

Paul

3

Maybe I was not very clear, the value list options are there but are combined. I would like to choose weather an Item was in the diplay list, OR the field not both.

Example

Fields:
Code, Service_Description

I want to display the Service_Descrition in the list and enter the Code in the field.(This is possible)

I want to display the code in the field after the selection has been made.(This is not possible)

I hope I did not confuse anyone worse.

Thanks for the response

4

You mean: When you click the field, you get a dropdownlist with all the Service_Description’s, but as soon as you selected a value, the Service_Description disappears and the underlying Code is shown int he field?

Mmm, Maybe for that you have to do some workaround, like two fields on top of eachother, with an onfocus method, showing the combobox field and an ondatachange method to show the field again with the code.

What is possible now is showing both the Code and Service_Description in both the dropdown and the field afterwards, with only the Code written into the dataprovider.

Paul

5

Yes, That is what I am doing now.

I guess I will try a work around as you mentioned. I was hoping to avoid alot of layered fields and workarounds on this build like I did using FM, but this is the first one and it’s not that important, so I have no complaints.

Thanks for the help.

6

why whould you have 2 different things in the field and in the list?

are you wanting this:

in the list i have:

x,y,z

but when i select ‘x’ i get ‘a’ shown in the field??
This looks very very confusing for people.

what i could think of is a longer description in the field like

x a
y b
z c

and then only a (or x) is displayed in the field if x a is selected in the list.
Are you trying to do that?

7

I have
x= Service descrition
Y= Service Code

I have a line item field that is called Service_Code.
I have a value list that pulls values from a seperate table attached to the Service_Code.
I want to select ‘X’ from the value list, and have ‘Y’ returned in the field.
I want to DISPLAY X not Y in the field.

To get the required result , I have the value list attached to the Service_Description field that displays X. The Service_Code utilizes a look up to auto enter the correct code.

Or I could layer a field as mentioned before.

I can work around this, it’s no big deal.