AnsweredAssumed Answered

newbee question

Question asked by lidyswan on Feb 8, 2013
Latest reply on Feb 11, 2013 by philmodjunk


newbee question


     Hi all,

     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,

     regards, swanny