Hi There,
Catalog Item Form
I have a use case where I need to retrieve and display information based on looking up a user in the sys_user table.
Not all the information is in the sys_user table but it is in related tables in some way mostly in the cmn_location table via another reference.
I need the information to change or update as soon as the user is selected so it can be displayed.
EG If user John Smith Is selected I need the location name assigned against John smith to appear below the user name as a default value in a read only variable. Then based on the location name that appears in that variable I need the division assigned to that location to appear in another variable field. Then the next variable field would be the Phone Number in the location table.
If another user is selected i.e. the user David Brown is selected then I want the above variable fields to update with the location details for David Brown.
In this use case all the returned details would be unique to the user and already values assigned to existing fields so I am not looking for an array of values just the actual values that are assigned to the fields I need to display.
Hopefully that makes sense and hoping someone can help.
P.S. I have had some success so far in that I can display and update the location of the selected user however the next hop to retrieving the additional information from the location table is where I am stuck.
