I am working on designing and creating a survey for inventory check-out for new build(s) in the field by our electric linecrew. I have been able to program a series of drop-down entries for the foreman to choose from by looking at a table in one of our Hosted Feature Layers. They choose the inventory number in one drop-down and then choose the description of the inventory product in the next.
What I am trying to do is for the Description to auto populate based on the selection they choose in the inventory number.
See Attachment(s)
STOCK NUMBER #1 is the field the foreman selects the inventory number (looking at the table in the Feature Layer).
DESCRIPTION #1 is the field I would like to auto populate based on the selection in STOCK NUMBER #1
FEATURE LAYER TABLE is the table the survey is looking at for the drop-downs.
EXAMPLE: If Foreman selects 1040 in STOCK NUMBER, the DESCRIPTION would auto populate to Anchor Rod Triple Eye 1" X 8'.
The goal is to help the foreman and save time.
Thank you for any advice u can give