I'm not sure if this a query problem or a table

i think its query

I have 3 Tables
Student
Class
Group_Leader

the Group Leader has a name (not primary Key) and a group (A or B)
the class has the same

from the student table what i need is to be able to assign a class for the correct group without knowing the group

for example i pick leader1 who is in group A and i have a 2 classes in Group A and 1 in Group B

I need in a lookup field to be able to select ONLY the Group A classes

can this be done - if so, how?/

Drogo

I'm not quite sure what you want, partially because I'm not sure if I understand your table structure and partially because I'm not sure what you want from the looking up the groups based on selection of your leader.

Maybe you could list fields in each tables and how they are related to each other, then explain exactly what you need from the lookup.

Ok I will only post the relevant fields

Group_Leader:
Leader_ID (Primary Key, AutoNumber)
First_Name(Text)
Surname(Text)
Group(Text)

Student:
Student_ID(Primary Key, AutoNumber)
First_Name(Text)
Surname(Text)
Group_Leader(LookUp of Group_Leader.Surname)
Class(LookUp from Class)**

Staff:
Staff_ID(Primary Key, AutoNumber)
First_Name(Text)
Contact_Type(LookUp of different types manually inputted, teacher being relevant type here)

Class:
Class_Number(Primary Key, AutoNumber)
Teacher(LookUp from query of all staff with type "Teacher")
Group(Text)

**This is the problem, what i need is the students Group_Leader has a group, i need to get that group (A or B) and find all the classes that are from the same group ONLY and list those in a LookUp field

any better??