Solved Multi User Multiple Record Selection Clashes

[LGDGlen]

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

 

[arnelgp]

you can "virtually" save the selection in a Local variable.
or save it in a Local table.

see this demo.

 

[LGDGlen]

@arnelgp thanks for getting back to me, i'll take a look at the demo and see if it solves my problem, sounds like it might though

 

[LGDGlen]

@arnelgp this is (almost) exactly what i need. a little extension that if you can give me some pointers on i'd appreciate it.

Currently the form i have has "Customer" "Supplier" "To Date" "From Date" filters that show the records i want and then i want to be able to:
- Select individual records from the filtered records - This is shown in your database example and i appreciate it
- There is a checkbox on the form that is "Select All/None" and what this currently does is set the massProcessingSelection field to Yes or No for the filtered records. This is something i need to understand

Is there a way to mark all the filtered records selected or deselected on the use of the checkbox?

(apologies if its obvious as this is my first database so i'm learning as i go)

 

[arnelgp]

here is another "same" sample but with "fake" checkboxes"

 

[LGDGlen]

@arnelgp awesome, downloaded and looking now

 

[LGDGlen]

@arnelgp thank you i think this has given me all the tools i need to create something that works for me from your suggestions, i need to plan how to adapt it and may come back with any further questions but for now i think i have everything in those 2 examples to get to where i need to be

 

[arnelgp]

goodluck, comeback if you got stuck.

 

[arnelgp]

the main point on the demo is the "hidden" textbox (selected IDs)
and the conditional formatting (showing/hiding the "checkbox").

 

[LGDGlen]

@arnelgp just to update, i have adapted it to my needs and it works brilliantly thank you so much for your help it really helped me re-asses what i was doing and how i should do it and will help me going forward as i am going to have to do more of this in different areas so i'll re-use this alot