Jump to content

Showing Second Field in drop down?


MSPJ
 Share

This topic is 5789 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi -

I'm trying to create a way for a user to choose a surrogate primary key (serial number) but only see a more descriptive field. FM has the ability to show a value list based on a field, and only show a second variable. However, this seems to only work correctly with popup menus. With a drop down, you see only the second field when you click the field, but when you leave it, you see the actual variable assigned to the field (in this case the surrogate key). This will be confusing to user, but I prefer not to use a popup because it doesn't allow autofill by typing first letters.

Any way to do this? Or some other way to hide the primary field so I could show the descriptive field in merge field?

Example:

Person ID = P00001

Person Name = Michael

Want to assign the ID field, but have the user only see values in Person Name field both when choosing, and after leaving field. Or else not see anything when leaving field, since I could show the Person Name elsewhere.

Not sure why it works in Pop Up but not in drop down.

Thanks!

Michael

Link to comment
Share on other sites

It's really very simple. Take your Id field and set it to transparent and set text to the same color as background. Place your name field on top of your ID field and set behaviour so that you cannot change in browse mode. Place the name field on top of the id field. Now when the user clicks on the name field they get a drop down of the ID + Name field. They choose the correct entry and all they see is the name.

HTH

Al

Edited by Guest
Link to comment
Share on other sites

This topic is 5789 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.