I have a form that's pulling in items from different columns of this list:![List][1] On the form, you have the option to select Job Title and, later on the form, Systems Access, ![Categories][2] Since these two columns are from the same list, is there a way to have the corresponding Systems Access automatically populate in the Systems Access drop down when a Job Title is selected in the Job Title drop down? Thank you!
EDIT: I tried adding this code to the NewForm.aspx in SP Designer, but it didn't work:
<script language="javascript" src="/JSLibrary/jquery-1.4.2.min.js" type="text/javascript">
</script> <script language="javascript" src="/JSLibrary/jquery.SPServices-0.5.7.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$().SPServices.SPCascadeDropdowns({
relationshipList: "SystemsAccess",
relationshipListParentColumn: "JobTitle",
relationshipListChildColumn: "SystemsAccess",
parentColumn: "JobTitle",
childColumn: "SystemsAccess",
promptText: "Choose State...",
debug: true
});
});
</script>
(images removed)