Advanced Reference Qualifier Based-On Current Variable

[codechaser]

Need help setting-up an advanced reference qualifier that uses the 'u_term_code' field from the *Term drop-down as a dependency and returns a list of courses that share the value.

javascript: u_term_code = current.variables.u_term_code;

Above, is the code I currently have.

[Michael Ritchie]

I am not sure I 100% follow since you are prompting for a single term and then selecting a single course.   Is the section an attribute you would prompt for in between term and course?   Not knowing the data its hard to answer.

[codechaser]

Not a problem - I'll try and describe as best I can.

We are still utilizing two tables, i.e. Term and Course.   When a user selects a term from the form, it presents a list of courses for that term.   We know this works.   However, I want to go a step further and return a list of sections that meet the course value.   So, if Section 1 of History is taught in the Spring, for example:   I would like to return value for section, using a similar method: Term: Spring 2017-> Course: HIST-> Section: 1 .

Currently, 'u_section_number' is a field on the Courses table.   My thought was our advanced reference qualifier we used under course would be used for section, and look something similar to javascript: "u_section_number="+current.variables.courses_req.   However, this does not return any values.

To summarize, we need to start with a broad scope (i.e. Term) and get as granular as course section and instructor, each drop-down utilizing the field before it as a reference qualifier to return the appropriate values.

[Michael Ritchie]

Thanks for the further details.   Just so I am clear, if I choose Spring 2018 and type in HIST, would I have multiple HIST records with different sections?   How does the user know which course to select?

Since section is an attribute of course, you won't get any results other than the value for the course selected.   If you simply want to display the section of the course chosen you can definitely do that through an onChange client script where the value is populated into another variable after the course is selected.