Minimize Search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three tables. Countries, Schools, Groups. Countries table has a feild
called Country_Name which contain countries Names. Schools table has a feild
called School_Names which contains schools of that country and has a
relationship with the Country_Name feild in the Countries table via a
Country_Name feild of its own. Groups table contains information about
individuals groups in the schools. The problem is there are more than 7000
schools thus selecting the school in the Groups table by means of a
relationship with the Schools table gives me more that 7000 schools to select
from. Is there anyway I can limit the list of schools to pick from in the
table by preselecting the country?
 
Why don't you create an entry query where it prompts you to enter the name of
the country. It will then produce the schools only for that country...
 
An entry query would work. How do I do that. Do I create a query that looks
up the country name from the countries table then create a feild called
country name in the groups table that looks up the query? Its been a long
time.
 
Back
Top