Displaying one to many relationships

[markeh]

Hi everyone,

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.

[KarelB]

Straight out of the box MATE does not handle one to many relationships.
This doesn't mean you cannot create something yourself.

There are forum discussions on master-detail grids you could use or
I solve this issue in the following way:
- create a new icon
- clicking the icon passes the record id and starts a jQuery dialog
- the jQuery dialog opens an iframe with a new MATE page with the many relations for that particular record.

[admin]

This should be possible with mate. Did you try making the junction table the main mate table and do joins on the other two? Take a look at the join example on how to do this.

With this method you will be able to add and delete customers from groups. In order to add a new customer or group you can create a custom icon that triggers a modal box or pop up window like KarelB was saying.