portal inside portal
I realize that this can't be done, but what is the right approach to the situation?
In a Curriculum table there are fields keyID, grade, year and Subject
In table GradeYear there are fields KeyID, grade, and year
These two tables are joined by an = relationship Curriculumm::Grade to GradeYear::Grade and Curriculum::Year to GradeYear::Year
In table Textbook there are fields KeyID, and textbook This table is joined by Textbook::KeyID to Curriculum:KeyID
In a layout from the table GradeYear I want display the Subject and then the Textbook when sorted by the GradeYear::Year and GradeYear::Grade
Textbook::Textbook and so on