With the following scenario:
- You organize Concerts
- Concerts have Bands
- Concerts also have BandMembers
- Bands have BandMembers
As such there is a one-to-many relationship between a Concert and Bands, and between a Band and BandMembers, and between a Concert and BandMembers.
Bands and BandMembers don’t live outside of Concerts.
(I couldn’t think of a better example. It makes sense in our data)
One-to-many field editing.
When editing a one-to-many field, every possible foreign entity is listed, even if it makes no sense.
In that case, editing a BandMember’s Band will list every single Band of every Concert, even if the BandMember’s Band is in another Concert!
It should be possible to filter the dropdown to only show Bands which are in the BandMember’s Concert.
Either via a UI help like selecting sub-fields of relationships, or maybe via a specific notation:
I have found How can i filter my dropdown from relation? but I was hoping there was a nicer way to do this using the provided widget settings. Fingers crossed!
- Agent type & version: 8.3.3