deleting several records at once

[cardoza]

Hello, i am trying to write a script that will delete several records at once,

i have a database that tracks tool issuance to employees, (each tool has a unique serial number by which they are tracked) lets say I give employee robert 6 tools,

and then he returns 3 tools to me, how can I design a script or a way that those 3 tools get taken form his record and placed back into my inventory ?

thank you

[mr_vodka]

I dont think you should delete anything. Instead I think you should have historical records for tracking. I believe there are lots of inventory samples on these forums if you search for them.

[cardoza]

I don't care about historical data, I just want to know how to delete multiple records at once.

thanks.

[mr_vodka]

Okay. Well then try the Delete All/Found Records command. Once you have your set of records that you want to delete, this will delete them.

[cardoza]

thanks.