Really confused about how to add results from a data source to the form so that the info can be updated without affecting the actual data source.
Ideally I want to save a filtered SQL table to a collection. At most, it would be 5 records after the filter is applied. I see articles about saving a collection to a SQL table, but not the other way around. Is this possible?
I need the info displayed, need users to be able to select and update without actually updating the data source. I don't want the updates saved back to the data source.
Have tried things along the lines of ForAll(filteredDataTable, Collect(collectionName, etc)) with no luck