C
code_warrior
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?
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?