Information générale
Catégorie:
Codage, syntaxe et commandes
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement