Compare values based on Pre-Requisites
Hi, I need help in figuring out how to validate if the user currently registering for the training has attended the corresponding pre-requisite training. To elaborate, Trainings - Registrati...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendDivya,
I do not have a lot of time right now, but here is a quick thought.
If you make a combined text summary field on the Course record to summarize the course codes for all the Pre-Reqs, then the course will "know" its Pre-Reqs.
Then that can be lookup up down to Trainings.
Then that can be looked up down to Registrations.
Similarly, I assume that 1 User has Many Registrations (you did not show that relationship), so you could summarize all the Registrations where the User has passed the course.
Then you would need to have a formula to calculate if each Pre-Req was contained in a string of course codes that the user has passed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I do not have a lot of time right now, but here is a quick thought.
If you make a combined text summary field on the Course record to summarize the course codes for all the Pre-Reqs, then the course will "know" its Pre-Reqs.
Then that can be lookup up down to Trainings.
Then that can be looked up down to Registrations.
Similarly, I assume that 1 User has Many Registrations (you did not show that relationship), so you could summarize all the Registrations where the User has passed the course.
Then you would need to have a formula to calculate if each Pre-Req was contained in a string of course codes that the user has passed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------