Jump to content

Show 2nd value


ricardito
 Share

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

Recommended Posts

I have a client ID value list I'm using in a global field for a relational filter, when the user chooses it I tell it to show the second item, the client name, however the (long) ID is shown in the field after they click out.

Any ideas on how to capture the name and have it show in a field?

Thanks.

Link to comment
Share on other sites

Hi Ricardito:

Alternatively, that "first value" ID can be concealed if you format the field as a Pop-up Menu. The trade-off is that your users will have to use the mouse rather than being able to tab into the field ... at least it's an option.

I also like Breezer's suggestion. Your global field becomes a "picker," and a second Table Occurrence pulls the Client's name. Just place a field from this "name" relationship layered directly (pretty much) over the ID picker field ... disallow entry into this "name" field. The upside here is that users can tab into the "picker" field.

There are other ways still. Let us know.

Link to comment
Share on other sites

This topic is 5724 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.