Hello everyone,

I've three tables, clients, groups, mbship. Every client cn be a member
of one or more groups. So I decides to make the following:
table client
id_cl
etc

table groups
id_gr

table mbship
id_mb
id_cl
id_gr

I want to display the clients as a parent records and the groups as the child records. With an sql statement like
select client.id_cl, groups.id_gr from ... ;
where client.id_cl=mbship.id_cl ;
and client.id_cl=select_id....
it works, but not in a form.
Any hints outside there?
thanks Wolfgang