Design Advice

I'm trying to design a database that handles Clients, Cases, Individual and Group Sessions. My problem is that a client can have individual sessions and belong to more than one group at the same time, so I have a many-to-many relationship to deal with. Also I'm trying to design it so that I can have a form that when a group is selected from a drop down it shows all clients assigned to that group and will let me enter new session data for them.

Just looking for some advice on how to handle the relationships.
Maybe someone could show me how they see the relationships working.

My take is that the session is linked to the case not the client, I could be thinking incorrectly?

Thank you,

tblClient
tblClientCase
tblCaseSessionLog
tblClientCaseGroupLink
tblGroupscreate look up tables to handle those relationships.|||What do you mean? Can you explain?

Thank you,|||When a case can have only one client, you can simply add the clinetID to the case.

if a client can be in multiple Groups you need

a master table of Clients
a master table of Groups

an additional table to link them that contains 2 columns (ClientID, GroupID)

this extra table allows you to add additional rows for each group a client belongs to.

You'd need to better define what the SessionLog is for before i can comment on that last question.