Still another value list related records problem

Classic Servoy
1

I have a form based on a table called proposals_people. Two of the fields of that table are id_projects and id_proposals.

The id_projects field is a combo box which is linked to a valuelist of my projects table. It works fine.

What I want is for the id_proposals field to only display the proposals of that project.

I have a table called proposals which has a many to one relationship with the projects table. The proposals_people table has a many to one relationship with the proposals table.

I have a relationship called proposals_people_to_proposals on id_projects .

If I create a related valuelist for the id_projects in the form based on the proposals_people table, and I set the valuelist as a “No N-M Relation”, using theproposals_people_to_proposals relation and pick the appropriate fields to show in the list and return to the dataprovider, I don’t get any values in the id_proposals control even when I select a project in the id_projects control that has many related proposals.

Can you tell me what I am doing wrong?

2

should work fine i do the same with some solutions i am working on.

relation:

proposals_people.id_project → proposals.id_project;

build a valulelist on that one with display the proposal name and return the proposal id.

use that valuelist in a combo (or typeahead)

if this really isn’t working please send me an sample which shows this because this should work fine.l

3

Here is a sample.

I believe it is exactly as you described – but its not working…

Thanks for your help.

4

they do show fine!
You have an error in youre valulelist!
You don’t set any value/column as youre display column…
Both (id and title) are set returnvalues.

5

Yup. That was it all right…

Sorry to be so lame!!!