I'm hoping someone would be kind enough to give me some advice or point me in the right direction with a problem I'm having. I have customers which can be a member of several groups and I'm struggling with how I can work with this using MATE.
For example I have:
a customer table - customer_id, customer_name, customer_email
a group table - group_id, group_name
a customerGroup junction table - customer_id, group_id
I use MATE for the customers table, how can I also display the groups the customer is in? and then add a customer to or delete a customer from those?
I'm hoping there is an example of something similar being done, it seems like something that might be commonly performed. I hope I've explained this well, any help or advice would be very much appreciated.