Hello I have a problem :

I'm making a component for volunteers registration. The registration is mainly a form with the name and 2 fields : "banned areas" and "preferred areas" ( the volunteer can choose one ore more "banned areas" and on or more "preferred areas" from a drop-down list".

I have several tables :
- table "volunteers"
- table "areas"
- table "volunteer_N_bannedareas" (a pivot table between "volunteers" and "areas") for "banned areas"
- table "volunteer_N_preferredareas" (a pivot table between "volunteers" and "areas") for "preferred areas"

I can creaté the form "volunteer" with the "builder > pages > layout > item" form with the fields :
- name
- prefered areas : ( Type : N:m || Pivot table : volunteer_n_preferredareas || Value field : Title)
- banned areas : (Type : N:m || Pivot table : volunteer_n_bannedareas || Value field : Title

But when I "run in sandbox", the view does not display the "prefered areas" field but it displays the "banned areas" field,

what I'm doing wrong ?

Philippe

Try it with two different fieldnames (you now have 2 "areas")

This is a limitation at the moment. It is not possible in the builder, but you can edit the relations in your models constructors.

I should have a look, in this case. It is possible to add the feature.