I am trying to customize the Add/Edit forms for a custom list to allow the user to select options in a Cascade manner. The user must select a Customer and based on the choice the ComboBox for the Projects is filtered (showing only the projects from the selected customer).
I was able to solve how to filter the values by unlocking the Data Card and adding a new DataSource pointing to the "Projects" list, then on the Items property I added Filter('Projects',Customer.Id=DataCardValue2.Id), DataCardValue2 is the ComboBox that shows the Customers, the Title field will be the DisplayField and SearchField.
When I select a Customer it successfully filters the values on the Projects combobox, but when I select a Project value and click on Save it does not stores the selected value, it stores Null.
The Update property of the DataCard containing the Projects combobox is successfully tied to the ComboBox.Selected and the DataCard is also tied to the "Project" column of the main data source.
What am I missing.
When I delete the card and add the default card (with no cascade) it stores the data successfully, but I need the cascade and when I made the change to filter the data (cascade) it stops working.