Asigning cases and then remove them from the table

[megatronixs]

Hi all,

I'm trying to make a query that will be used to asign cases. I have a table that gets updated from a intranet site where I take the data from. Some team members will Asign from the access table the cases using drop down box to choose the analyst, then a button should move that case into the working table, and on the same time the cases should be gone from the table.

What would be the best approach to get this done? Is it also possible to select multiple records in the same time?



I will start working on this now, so having some tips could help out.

Greetings.

[June7]

Best approach is to NOT move records between tables. Instead, change a value in a field. However, if you must move records from a temporary import table to a permanent table, can use an INSERT sql action for the 'move' then a DELETE sql action to delete from the 'temporary' table. Code would be behind a form. 'Moving' multiple records might be possible with an INSERT SELECT sql action.