Information générale
Catégorie:
The Mere Mortals Framework
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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement