I have a form based on a table called panel_members. Two of the fields of that table are id_projects and id_panels.
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_panels field to only display the panels of that project.
I have a table called panels which has a many to one relationship with the projects table. I have a relationship called projects_have_panels. There is also a relationship between panels and panel_members called panels_to_panem_members.
If I create a related valuelist for the id_panels in the form based on the panel_members table, and I set the valuelist as a “No N-M Relation”, using the projects_have_opanels 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_panels control even when I select a project in the id_projects control that has many related panels.
Can you tell me what I am doing wrong?