Forum Discussion
Thanks, Chayce. I hadn't considered making the reports directly editable through grid edit, but that is a good thought and would serve the purpose here, if not the cleanest looking. Was hoping there might be a cleaner solution that I wasn't seeing but I had many of the same thoughts you mention about the challenges with each of the different options. Good points on the need for additional maintenance/checks if we do pursue the multi-select approach.
------------------------------
Oana Whalen
------------------------------
If you're comfortable with playing with your own primary keys, you could try the multi select route but when you create the records you make the primary key something like [Employee Email] - [Related Presentation]. You can then add an 'Applicable' flag that you pull the lookup of the multi-select and bring that down to use a Contains function to see if that persons name still appears in the list of employees presenting. This alleviates having to worry about only creating certain people or deleting them because then you can just filter out the ones that aren't applicable.
I tend to agree the user experience of the multi select is typically better for the everyday user. The above is still the more complicated route than inline grid edit but an option nonetheless.
------------------------------
Chayce Duncan
------------------------------