1. Create an unstored calc in the Student Table. Formula: "Current"
2. Make another Table Occurrence (TO) of Academic_Year. (ie - "Academic_Year_Current")
3. Make a relationship between the field created in step 1 and the status field in Academic_Year_Current.
4. Use an auto-enter field that sets the value to: Academic_Year_Current::Year
That should create a relationship that related the year that is marked as current...and then new records will auto-enter the year from that specific TO.
Thanks that did the trick.