Thanks for the response!
I'm not sure I know how to accomplish what you're describing, but let me give it a shot based on what I can figure out from code snippets:
"attaching to the change event" - Is this all I need to check if the parent field (a lookup column) changed?
So if the column changes, I need to get its value and the value of another column...
TeacherFieldValue = TeacherField.Obj.find("option:selected").text()
SchoolFieldValue = SchoolField.Obj.find("option:selected").text()
And then use them in a query to find the one record I need...
<FieldRef Name='SchoolField' />
<FieldRef Name='TeacherField' />
<FieldRef Name='VisitDate' Ascending='False' />
CAMLViewFields: "<ViewFields><FieldRef Name='" + ChoiceFieldStaticName + "' /></ViewFields>",
completefunc: function(xData, Status)
So, given that one result, I need to select the matching value on my choice field (either 0, 4, 7, or 10). This is where I'm getting stuck... I usually figure out how to code based on examples, but I haven't found any. So given the choice column, we'll call
it "ChoiceField", and those 4 previously mentioned choices, how would I select the one returned by the query?
Also, is my code logic even sound?
Thanks for the help :)