Get Lookup value of another column


Posted by jcmeyer - Jul 7 ’14 at 03:30

I have a list with 3 columns:

FileNumber, ContactPerson, City

FIleNumber is unique


In another list I have a lookup column on 'FileNumber'.  I want to pass the value of column ('City') to a variable after selecting the associated FileNumber.  I will then set the value of City in the new form automatically onChange to FileNumber lookup.


I can get the record ID of the lookup using fd.field('Lookup').value

I can get the text of the lookup (FileNumber) using fd.field('Lookup').control('getSelectedText');

Is there any way I can get the text of City after selecting a FileNumber in the lookup?


Thank you

Displaying 1 to 10 of 10 messages