October 30, 200916 yr 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
October 30, 200916 yr Author Just a clarification. When I say I want a separate occurence, it's of the all students table.
October 30, 200916 yr 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
Create an account or sign in to comment