Insert the Serial Number in the Serial Number catalog variable.

[Rhonda9]

How can I get the  Serial Number related to the Device Model Variable to auto populate into the Serial Number variable below the device model?

The requested for assets appear in the Device Model (which is in the from the hardware_alm table) but I want the serial number which is coming from the same table to display the device serial number.   I would like the related Serial Number variable to auto-populate when the Device Model is selected.   How can I accomplish this?

I tried creating a catalog client script but its not working.   

Thanks in advance for your help.

[Rhonda9]

Yes, it is referenced to alm_hardware, The student is a reference field.    I think I see what I did

[Brad Bowman · Accepted solution]

student_serial_number needs to be a single line text type variable as it is not referencing a record on a table, rather a field on the record that you already have a reference variable for.  Here's an explanation of a way to do this without a script, that I neglected to mention earlier.

https://www.servicenow.com/community/developer-articles/catalog-data-lookup-definition-on-any-table-... 

[Rhonda9]

I just want to thank you for taking out the time to help me with my issue.

I finally got it working with the Catalog data look up definition.  It took me less than 5 minutes.  

[Brad Bowman]

That's great to hear!

Connect with me on   https://www.linkedin.com/in/brad-bowman-321b1567/

[Lkowalski]

@Rhonda9 @Could you please provide solution that works for you?

Thank you!!!