fields that use the Text Index option,

[RET]

I have a database that has fields that use the Text Index option, with the max set to 7 repetitons for each field.

Example: Field 1 = class name (each repetiton has different data)

Field 2 = time (each repetiton has different data)

Field 3 = teacher (each repetiton has different data)

Each record is by student name. I would create a layout that would make this easier to use. I would like to have one layout that I could show all the student in that class for that teacher. No matter how hard I try I can not get this to work

[BobWeaver]

You would be much better off by scrapping the repeating fields and using related files to hold the class and student information. You have a many to many type of relationship, in that each class can have many students, and each student can have many classes. I would set up a class file with the class info, a student file with the student info, and a join file that has a record for each instance of a student in a specific class. A portal can be placed in the class file to show all students in a class, and likewise, a portal can be placed in the student file to show all classes in which the student is enrolled.