I have a value list that returns a company ID but also displays the company’s name and city. Some companies have multiple locations and the value list only shows the first location.
For example:
123 Motorola Inc. Schaumberg
654 Motorola Inc. Huston
985 Motorola Inc. Plantation
Say I have a type ahead field using this value list. I want to be able to type in, “Moto” and see ALL 3 locations. If I select “Motorola Inc. Huston” it will set the field to 654.
What I currently get is a single instance of Motorola Inc.
Is there a way to make this work? I tried to build a calculation to concantenate the company name and city but it did not work.
Any other options? Could this be a feature request?