# Valuelists in 3.5.7

**URL:** <https://forum.servoy.com/t/valuelists-in-3-5-7/9744>\
**Category:** Classic Servoy\
**Created:** [October 13, 2008, 5:28pm UTC](https://forum.servoy.com/t/valuelists-in-3-5-7/9744 "2008-10-13T17:28:16Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![nric](https://avatars.discourse-cdn.com/v4/letter/n/9de053/32.png) [@nric](https://forum.servoy.com/u/nric)\
**Post date:** [October 13, 2008, 5:28pm UTC](https://forum.servoy.com/t/valuelists-in-3-5-7/9744/1 "2008-10-13T17:28:16Z")

</div>

Hi,  
I get an error of invalid input (the dataprovider is integer and the value is text) when changing values in table view.  
I’m not sure if it is a bug or wrong usage, but for sure the behavior in 3.5.6, where I have a different problem, is different.

When it occur:  
I display an Entry table in a table view for data editing.  
There is a combobox for the field “Category” (all values of the Category table)  
and a combobox “Value” the shows all available Values of the selected Category. There is a relation between table Entry and table Values, based on common field “Category”.

If I select the “Value” combo of record where is assign i.e. the category A and after a record with a different category, appears the error.  
Actually, each time that the valuelist have to change.

The same solution , in 3.5.6 gives no error, but changes the “value” according to last selected value.  
If for example I select the 10th value of category A and after press the combo of a record where is assigned the category B, it is assigned the 10th value of category B.

Do I have to set differently the relations of the valuelist ?

---

<div class="post-metadata">

**Author:** ![Andrei\_Costescu](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@Andrei\_Costescu](https://forum.servoy.com/u/Andrei_Costescu)\
**Post date:** [October 15, 2008, 9:23am UTC](https://forum.servoy.com/t/valuelists-in-3-5-7/9744/2 "2008-10-15T09:23:27Z")

</div>

There was a similar problem with list view and combos. That one was fixed - not sure it is the same one here though.  
Please create a case in our support system and attach a small sample solution we can use to reproduce the problem.  
[http://crm.servoy.com/servoy-webclient/ … oy\_support](http://crm.servoy.com/servoy-webclient/solutions/solution/servoy_support)

Thanks.

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\
**Post date:** [October 15, 2008, 9:34am UTC](https://forum.servoy.com/t/valuelists-in-3-5-7/9744/3 "2008-10-15T09:34:49Z")

</div>

I think I see the same problem. It seems to be table view only and the value list uses display/return values.

---

<div class="post-metadata">

**Author:** ![nric](https://avatars.discourse-cdn.com/v4/letter/n/9de053/32.png) [@nric](https://forum.servoy.com/u/nric)\
**Post date:** [October 15, 2008, 10:04am UTC](https://forum.servoy.com/t/valuelists-in-3-5-7/9744/4 "2008-10-15T10:04:44Z")

</div>

Case created, with attached sample solution.

I switched to list view and it works properly.

---

<div class="post-metadata">

**Author:** ![nric](https://avatars.discourse-cdn.com/v4/letter/n/9de053/32.png) [@nric](https://forum.servoy.com/u/nric)\
**Post date:** [December 11, 2008, 6:32pm UTC](https://forum.servoy.com/t/valuelists-in-3-5-7/9744/5 "2008-12-11T18:32:39Z")

</div>

Hi to all,  
While waiting for the fix I have used a list view, that has a different problem.

In my Entry table I have two combos. One for the “category” selection (from the categories table) and one for the “value” selection (from the values table).  
The Value" table has a composite key (category\_id and value\_id).  
So, there is a relation between the Entry table and Value table, based on the category id.

While selecting a row, the lookup description of the various “values” changes by taking the description of values with same id, but different category.

Is it a bug ?

---

<div class="post-metadata">

**Author:** ![nric](https://avatars.discourse-cdn.com/v4/letter/n/9de053/32.png) [@nric](https://forum.servoy.com/u/nric)\
**Post date:** [December 12, 2008, 9:54am UTC](https://forum.servoy.com/t/valuelists-in-3-5-7/9744/6 "2008-12-12T09:54:16Z")

</div>

By using the type ahead control instead of the combo, it works correctly.

Ric

---

<div class="post-metadata">

**Author:** ![mike65](https://avatars.discourse-cdn.com/v4/letter/m/bc79bd/32.png) [@mike65](https://forum.servoy.com/u/mike65)\
**Post date:** [December 17, 2008, 4:53pm UTC](https://forum.servoy.com/t/valuelists-in-3-5-7/9744/7 "2008-12-17T16:53:11Z")

</div>

_nric wrote:_  
_While selecting a row, the lookup description of the various “values” changes by taking the description of values with same id, but different category._  
_Is it a bug ?_  
Yes. I think it is a bug Servoy. We have lost a lot of time.

_nric wrote:_  
_By using the type ahead control instead of the combo, it works correctly._  
Yes, I too have noticed that most(three) valuelist on the same line in tableview do not work in combobox (only the first!), But putting the second and a third type ahead, then work (it seems).  
Three combobox in tableview in Servoy 4.x work (it seems).

I hope this is at least comforting to Nric.  
I have the same problems outlined by nric, and explained in the post of 5-12-2008 to:  
[http://forum.servoy.com/viewtopic.php?f=22&t=11204](http://forum.servoy.com/viewtopic.php?f=22&t=11204)  
Windows XP  
Java 11.0  
Servoy 3.5.7
