I have this problem; Showing all items inside a combobox that are related to the selected items on another combo box will only show the ones related to the last select item.
I have 2 combo boxes, Media and Networks inside the Booking Calendar Form>> where a network can be linked to one media and a media can be linked to multiple networks
now i have 2 combo boxes inside my form:-
1) Media combo box
-Items:-
With(
{
_Start:
Filter(
Media,
StartsWith(
Title,
Self.SearchText
)
)
},
Sort(
_Start,
Title
)
)
DefaultSelectItems:-
Filter(Media,ID in Filter(BookingCalendarMedia,'Booking Calendar ID'=ThisItem.ID).'Medium ID')
2) Network combobox
-Items:-
With(
{
_Start:
Filter(
Networks,
StartsWith(
Title,
Self.SearchText
) And 'Medium ID' in ShowColumns(BookingCalendarMediaComboBox.SelectedItems,"ID")
)
},
Sort(
_Start,
Title
)
)
DefaultSelectItems:-
Filter(Networks,ID in Filter(BookingCalendarNetwork,'Booking Calendar ID'=ThisItem.ID).'Network ID')
now when i select the first media item >> the related network will be shown correctly >> but when i select the second media, only network related to the newly selected media will be shown, while the previous networks will be unselected.. any advice how to fix this?
