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.
The field 'u_term_code' on the courses table is now referencing the 'u_term_code' field on the terms table, which is a string. I re-populated the courses table to match this, but is now displaying the sys_id in the term_code field.
I am including some screenshots, below:
Consequently, adding the Advanced reference qualifier 'javascript: 'u_term_code = '+current.variables.term_req; ' under courses does not return an answer.
I verified there is nothing in the ref_qual_elements field in courses. Below, is a screenshot of the terms table. Currently, the Term_Description field is being displayed on the form.
If you click one of the term codes in this list:
Does the Term show up with the term description in your Term Code field versus the SysID? Please also confirm that your term_req variable is also a reference to the term table.
Here is a screenshot of the two fields on the form, itself.
As you can see, the term description does display, correctly - but no values are returned under courses. The only thing I can think of is the term field is a string on the Term table, which courses is referencing. At the moment, we have to hard code these variables for testing purposes.
