MTM Schedule Events Cancellstion-davegri-v03.zip
Ed, see attached.
This version addresses concerns except for associate members.
User can enter cancellations first.
Only IsActive=Yes members are processed.
Report exists for scheduled but not attending
Report exists for Not cancelled, not attending
Report exists for cancelled, but attending anyway
I see no easy way to mix associate and regular members as their requirements are opposite. It would probably be better to have separate forms and reports for the associate members.