Setting up a table accurance

[mleiser]

I currently have a file that contains information about all of our students. I have a separate file that I create called high school and then import all of the high school students from the all students table. Then I use the high school file for whatever I need to do with the high school students (grades, etc.). The same for elementary school students. I would like to get with the times and create one file that has a table of students (and other tables. like grades, etc.) as well as a separate occurance called high school that only refers to high school students. SAme for elementary. SO I want to be able to go to a high school layout and only see high school students. How do I set up the occurance, keys, etc. Thanks,

mike

[mleiser]

Just a clarification. When I say I want a separate occurence, it's of the all students table.

[bcooney]

What you describe is the need for a subtype/supertype setup.

You may find this thread, and those mentioned by Fenton to be very useful. Graham Method link