I have a contact manager database. I have been given a task, I wanted to know how I can achieve that.
Contacts table, Projects Table, groups table
I have multiple contacts linked to same projects or a contact to multiple projects as well.
Same goes for groups.
My requirement is if there is an event suppose for a particular project, I want all the contacts in some groups to get an invitation. and would want to manually check if they attended or not. How can I achieve this.