I have created an app that loads data from a sql database into a collection, then displays this data using a textinput filter in a table for the user to pick a customer from. This all works fine but once a customer is picked and the user navigates to the next screen all the data is repeated in the table until the data is re-loaded. The user will need to go through the app process at least 5 times per day without reloading data (i.e. when they have a connection) so would end up with the rows repeated 5 times. There are no Loaddata functions in this sequence - can anybody help or explain this?
Hi I am doing a clearcollect when connected otherwise it uses loaddata - which i think was part of the issue as the load data appends the data. However even when this button is not used and just use navigate function - the data duplicates i have put a count on each page showing the number of rows in table and it doubles each time the user selects a custromer from the table.