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 โฆ
#SOLVED
@David_Hopkins, I donโt understand the question but I would like to remind you about the valid_if property on the column.
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?
@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.
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โฆ
@David_Hopkins I LOVE your first-comment hash-tag status indicator! What a great idea!
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
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |