I have 3 tables with many fields of which I will only mention the most important ones for this question:
- clients (fields: client id, clientname )
- groups (fields: group id, groupname, client id, category, date)
- groups_clients (group id, client id, creation date)
Clients and groups are related through 'groups_clients', so I can choose / add members to the group by selecting client numbers/names in a portal in 'groups'.
How can I show in a layout from the table 'clients' from which groups a client is a member? How can I automate this? One client can be a member of several groups and a group can contain several clients of course.
thnx in advance,