Checkboxes for tagging

[Tyra]

I need help in figuring out the best way to use check boxes to tag records in a list layout. The users need to be able to tag one or more records and then select a "delete" or "process" button in the header. Sound easy and pretty straight forward, until you throw in a large multi-user environment. The "tag" field is currently a text field, and I can see where one user may be tagging several records for processing while another is tagging for deletion, and it's just a matter of who hits the button first. It would seem that I would need something like a unstored calc field but, cant get my head around how to make it work. Thanks in advance for any help.

[mr_vodka]

What does tagging for deletion or processing do? Does one take priority over the other? It seems as though you need to figure out your business rules first.

[Tyra]

It's for a database that imports new records. The records have to be viewed be the users to determine if they are pertinent to that client or not. It's not something that can be automated. If not, then that record needs to be deleted.

If your asking why not just delete the un-needed ones and process the rest? That is the current structure. But it would speed up the entry of the valid records if certain ones could be grouped together due to having the same additional information that needs to be attached to them.

I could create two separate process, but was just hoping for a quick, and clean way to integrate them into one.

[Tyra]

I guess I could just use two radio buttons, one to delete the other to process. That would at least keep the processes separate. Just would be cleaner (Layout wise)to be able to use a single check box for tagging and then hitting the appropriate button.

[bcooney]

This thread might help you out: Marking Records