I am sure there is a probably an answer to this question somewhere in the forum but I have tried doing a number of different searches and I can't really find the answer, that is not to say its not here but I just can't put together the right search to find it. Here's hoping someone who reads this can direct me to the right post.
Problem:
I have a database that has multiple users, not many (less than 10) but still multiple people updating concurrently. Adding, updating and deleting records isn't a problem that all seems to be working as expected. The problem arises when a user needs to perform an action on a selection of records.
I have a table of deliveries with a massProcessingSelection Yes/No field which the user can check and then from an unbounded drop down list of actions update the records in a particular way. The problem as I see it is that if User1 selects 5 records and before they select the action and click the process button User2 could select a different set of records to do a different process and therefore User1s selection changes and if they don't notice they'll get a different set of results than they expected.
Question:
How can I create a method of selecting multiple records (anywhere between 2 to upwards of 100+) that is relevant to the local user ONLY and does not affect that selection any other user has made?
Thanks in advance
Glen
Problem:
I have a database that has multiple users, not many (less than 10) but still multiple people updating concurrently. Adding, updating and deleting records isn't a problem that all seems to be working as expected. The problem arises when a user needs to perform an action on a selection of records.
I have a table of deliveries with a massProcessingSelection Yes/No field which the user can check and then from an unbounded drop down list of actions update the records in a particular way. The problem as I see it is that if User1 selects 5 records and before they select the action and click the process button User2 could select a different set of records to do a different process and therefore User1s selection changes and if they don't notice they'll get a different set of results than they expected.
Question:
How can I create a method of selecting multiple records (anywhere between 2 to upwards of 100+) that is relevant to the local user ONLY and does not affect that selection any other user has made?
Thanks in advance
Glen