Many to Many Summary
Hi I'm sure there must be a way to do this natively, but I cannot get my head around it, so any help would be appreciated. My table set up is as follows: Parent: Lessons (Key: Lesson ID) - ci...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI would set up a table called Subject Topics where the key field is the hyphenated concatenation of the subject and the topic.
then set up a helper table with Record ID on of 1, ie, 1 Record, and use it to record the Focus Subject. Ie the Record ID# of the focus Subject.
use a relationship to Lesson Subjects to flag if the Subject is in focus and if so use a summary field to flag that the lesson is in focus for that subject.
look up a flag that the lesson is in focus down to Lesson Topics.
make the concatenated Key field of Subject Topics on the Lesson Topics Table by combining the Focus Subject Record ID with the Record ID Of the Topic.
set up a saved table to table copy to copy that concatenated field to the new Subject topics table where the Lesson was in focus.
create a URL formula button on the Subject to put it in focus in that helper table and to run the saved table to table copy.
Push the button on each of the 15 Subject records.
post back if you get stuck anywhere or contact me directly for one on one Assistance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
then set up a helper table with Record ID on of 1, ie, 1 Record, and use it to record the Focus Subject. Ie the Record ID# of the focus Subject.
use a relationship to Lesson Subjects to flag if the Subject is in focus and if so use a summary field to flag that the lesson is in focus for that subject.
look up a flag that the lesson is in focus down to Lesson Topics.
make the concatenated Key field of Subject Topics on the Lesson Topics Table by combining the Focus Subject Record ID with the Record ID Of the Topic.
set up a saved table to table copy to copy that concatenated field to the new Subject topics table where the Lesson was in focus.
create a URL formula button on the Subject to put it in focus in that helper table and to run the saved table to table copy.
Push the button on each of the 15 Subject records.
post back if you get stuck anywhere or contact me directly for one on one Assistance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------