I'm having trouble locating the link between the student record and their Homeroom.  I can find each faculty homeroom with no problem.  I can see the field SBHomeroom - but because we are running Registrar's Office - that's null.  I definitely have homerooms assigned to all students - and need this link so that I can create my customized report card.

Any suggestions would be greatly appreciated.

I found it!  It's in the EA7PromotionSummaries table, linked by StudentID.  I was looking for a table that showed Progression - but thought that PromotionSummaries related to the Promotion Schedules - not Student Progression.

The query referenced in BB136010 was helpful.

On to my next quest!