Attach signature to records added based on a Bulk Selection

[Robbo]

I've put together a small app to keep track of equipment consisting of an Equipment parent table and a child Transfer table. A new record is added to the child table recording who and when the equipment was transferred to and has provision for a signature. However the users want to be able to select numerous pieces of equipment and transfer them in one block without having to sign each record.

The easiest way I can think of is to use one of the UserSettings as a signature, and have the recipient sign first, then progress to the list of equipment, bulk select the equipment being transferred and initiate an action that creates new records in the child table, attaching a signature from the UserSettings to each, and finally clear the UserSettings ready for the next signature. 

I think I could make that work but it seems illogical to ask someone to sign first then select what they're signing for. I am after suggestions for a more logical approach.

[Steve · Accepted solution]

No matter how you approach this, there's no simple solution.

I'd create a new table with at least the following columns: the row key, an EnumList of Ref to the equipment table, and a Signature column. To bulk select and sign, add a new row to this table, select the equipment from the EnumList column, and sign.

[Robbo]

Thanks Steve. I should be able to make that work. I just need to figure out how to generate resulting reports by worker and by equipment but I think I can work that out. Appreciate your help