I am developing a form to add or update records in two related tables. I started by modifing a similar form found online. This essentially works by using advanced filter to store a subset of the records in another sheet. Then using those to show on the form and then add/update the original tables.
I am thinking that a better strategy would be to make use of array(s) to get the table records (all or a subset), filter the array to populate the form, then modify the array contents as required, then write the array(s) back to the tables - either with flag(s) to indicate which array elements were changed - or just the whole array.
The number of records involved is small-ish - a few hundred per year and only a rolling 2 years worth would be required.
Is this a better (and the best) strategy?
I am thinking that a better strategy would be to make use of array(s) to get the table records (all or a subset), filter the array to populate the form, then modify the array contents as required, then write the array(s) back to the tables - either with flag(s) to indicate which array elements were changed - or just the whole array.
The number of records involved is small-ish - a few hundred per year and only a rolling 2 years worth would be required.
Is this a better (and the best) strategy?