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 …

[David_Hopkins]

#SOLVED

[Challa_Ramakris]

@David_Hopkins, I don’t understand the question but I would like to remind you about the valid_if property on the column.

[Steven_Coile]

It’s not clear how “the REF breaks between Students & Registrations” when you “assign a student to a class [because] he’s no longer in the Students Pending Registration slice”. How is the Students Pending Registration slice involved in the Ref between Students and Registrations?

[David_Hopkins]

@Steven_Coile so…

Registrations runs against Student Registrations Slice… which in turn runs against students.

The slice says, if not registered then show. So, once the student is registered, they no longer appear in the slice.

I think im going to try @Challa_Ramakrishna’s recommendation, and revert the REF back to STudents with a “valid if” element that deals with the if not registered filter.

[David_Hopkins]

Ok… So I pointed all of the REFs back to the actual table data rather than a slice, and used the Valid IF with the Select statement that made all of the slices work correctly. So… a little fine tuning and all of my REF links are working again … and I only see the appropriate items in the list…

So… WIN!

Thanks Guys for your help and direction…

@Challa_Ramakrishna @Steven_Coile

[Steven_Coile]

@David_Hopkins I LOVE your first-comment hash-tag status indicator! What a great idea!

[David_Hopkins]

Thanks @Steven_Coile Its the only way i can find stuff that is still open… so… the first comment is always hash-tag open … then I just change it when the issue has been solved, or fixed, or what ever… lol