Can I do a lookup in a field?
Is it possible to do a SQL DB lookup of a value?
For example - one of my technicians needs to put it an image ID from another system. What she would like is in the Service Desk template to already display a list of all the image ID numbers, stored in another database.
It would be nice if we could query a DB and have that dataset be part of a lookup list in SD.
Is there a different way to help her? She just doesnt want to accidntly enter in the wrong or duplicate image number.