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.

[codechaser]

Thanks Michael!   I ran the above onChange script as a test and did get an alert message.

[codechaser]

Term: ec0aef84db4493008a1a3220ad9619fc Course: 6c4c8094db8cd3001e8c3c8f9d961914

[Michael Ritchie]

Please pull up a course record that it tied to the Term selected.   Click on Additional Actions and choose Show XML and see if "ec0aef84db4493008a1a3220ad9619fc" is found within that record.   If so, what is the field name that the value is in?

[codechaser]

Pulling up the course record that was tied to the term, selected shows only the sys_id for that course, 6c4c8094db8cd3001e8c3c8f9d961914.

[Michael Ritchie]

OK this is the issue.   How are courses linked to terms?   Can you post a screenshot example?   What type of field is Term on the course?   If it is a string type field, then you need to make it a reference for this to work efficiently.