Multiple Selecing

J

John

Hi all

First time i have used this so hopefully i will frame my
question correct.

i have tried creating a query with the following names.

Planner
Local Person
Judge
Scheme

each person is related through council id.

can i create a query so that for each person relating to
each scheme will come up. Basically so that for scheme 1 i
will be able to see the Planner Name, Phone, Local Person
Name, Phone, Judge Name and Phone.

If any1 can help i would be much appreciated because it is
really proving to be a predicament for me.

Thanks for the help
 
Top