Manipulating multiple selected records on a form

[petko]

I'm in need of the following functionality:

The user would select a bunch of records from a form and after a user trigger I should be able to run a procedure manipulating the set of records [FONT=&quot]according [/FONT]to the user selection.
How could I do this?

Thanks for any input

Peter

 

[arnelgp]

your table should at least have a yes/no (boolean) field, to tick which records to be included.
based on selected record you can run an sql query or an udf to process.

 

[petko]

Thanks arnelgp,

The ticking way I know but I would gladly avoid using one boolean just for that.
Is there no any way to refer to records in a form, selected by the user?

Peter

 

[arnelgp]

i am sorry, i dont know of any other approach of selecting a number of records or any number of non-continuous records.

 

[moke123]

one problem i have encountered using a boolean field in a table, with a shared backend, is collision when 2 people are running the same thing. I use a local temp database with a temp table and set the boolean value there to avoid any collisions.

 

[arnelgp]

you can use multi-select listbox if you don't want to add a boolean field.