Display 2nd Field from a List

[RyanESmith7]

Hi All,

 

I have a field on my layout that is linked to another table through an ID field. I want the user to be able to select the field using a drop down value list. So my first field is "COMPANY ID" which is a serial number, and my display data (second field) is "Company Name", which is obviously text. The display on the drop down looks like this:

 

 

So far so good. The lousy part, is after they have selected the company they want, the display in the edit box defaults back to the id number (like 342). Is there any way to get this to display the Company Name instead? 

 

 

 

Thank you in advance!

Ryan Smith

 

[Vaughan]

You need to format the field as a pop-up menu.

 

The ID appears in the drop-down list because that's the actual value that is entered.

[HALBURN]

Ryan, does this sample FM12 file do what you want?