Let me start from the top. My data management issue is as follows:

This is a one-to-many relationship. The 'one' is a teacher name. The 'many' refers to the schools that the teacher serves. The school table contains about 5000 records. I have a grid to enter the 'many' records. The 'many' table contains a foreign key for the school, which I am using a combo box to access by setting the RowSource to the following select statement:

select trim(SCHOOL.cSchoolName), SCHOOL.cId from SCHOOL order by SCHOOL.cSchoolName into cursor crsSchool

and the RowSourceType to 3-SQL statement. The 'many' table also contains other information like start date, stop date, notes, etc. I use this same style throughout my system for adding 'many' records to the 'one' teacher. This style works fine everywhere except in the school grid. I know combo boxes shouldn't be used to access 5000 records, but I am trying to stay consistent with the rest of my system.

Any suggestions?