Breaking References question.. So.. I have ...

[David_Hopkins]

Breaking References question…

So… I have the following structure…

TABLES Students - Student (key), Completed Date, Registered Classes (Registrations REF) Registrations - Student, Class (combined key) Classes - Class (key), Start Date, End Date, Registered Students (Registrations REF)

SLICES Current Students - students where completed date is null Current Classes - classes where end date has not passed Students Pending Registration - students where COUNT of Registered Classes = 0

Here is the issue…

When I assign a student to a class… he’s no longer in the Students Pending Registration slice… so … the REF breaks between Students & Registrations

is there a way to REF back to Current Students? while showing the Students Pending Registration in the registrations form?

Thanks again …