I have an order table that uses 2 value lists.
value list 1 lists a product group but selects the ID
value list 2 lists the products in the selected product group but selects the ID
The values are retrieved from a products table.
Value list 1 retrieves the values from the table directly.
Value list 2 retrieves the values via a relationship based on the value selected in value list 1 (in a field ofcourse).
This works fine when you insert new data in a listview. Although when you click out the product field (value list 2) you see the ID instead of the name.
When you commit the change and edit it again I never get to see the name again. Only the ID.
All this is in a listview.
Limitation or a bug?
I hope I make some sense.
Servoy Developer
Version R2 2.2rc7-build 325
Java version 1.4.2-38 (Mac OS X 10.3.9)