I am trying to Unrelate all the values from a combobox and then relate the values from a different combobox. Both combobox reference my Users table from another table (gblExistingCase.Users).
I have tried making a collection from the selected items and then unrelating the items
ClearCollect(colPeopleReportedTo_EC_NU,cmbPeopleReportedTo_EC_NDUC.SelectedItems);
ForAll(colPeopleReportedTo_EC_NU,Unrelate(gblExistingCase.Users,ThisRecord));
I receive the following warning "Value must be a data entity record"
Nontheless, when I relate the other combobox with the same structure I receive no warning and the relation is made. Namely:
ClearCollect(colPeopleReportedTo_NC_NU,cmbPeopleReportedTo_NC_NDUC.SelectedItems);
ForAll(colPeopleReportedTo_NC_NU,Relate(gblExistingCase.Users,ThisRecord));
I do not understand why when I relate there is no problem, if at the end both structures are identical.
At the end what I want to do is to unrelate all the values from "gblExistingCase.Users" and then relate the updated Users, regardless if some users are already related or not.
Any help to solve my issue is appreciated, I am not sure where the error is.
I would double check that your second combo box is referencing the entire table and not just a single column in that table.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2