Jump to content

fields that use the Text Index option,


This topic is 8479 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8479 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.