Minimize Search

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?

You can programmatically set the RowSource of the combo to limit its list.

Details in:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"code_warrior" wrote in message
...
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...

"code_warrior" wrote:

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?

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.

"Paul.S" wrote:

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...

"code_warrior" wrote:

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?