Hi Community
In the below example I am trying to create a form that collects basic data about a selected user. I am able to display the data that is held in the user table, however, I also want to display the information in another table that is referenced so almost a nested result.
When I select a user there is a value in the user record called location and i can display that without any issue if I update the user the location will also update based on the value of the different user.
I need some help with the next field. Each location has a value for "Division" and I want to display that when the location updates.
My Form
I am updating the location using a catalog Client Script and this is working for the location field just fine
How do I get the Division to display the value held in the location table reference above?
Hope that makes sense
