×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Show more info in the drop-down list.

Show more info in the drop-down list.

Show more info in the drop-down list.

(OP)
Hello!

I have a db created in Access 2003, that I'm rebuilding in FM. I prefer som of the GUI's in Access, and I'm trying to recreate some of it in FM.

I wonder if there is any way to have the drop-down lists to display values from more than two fields.

The reason I want this, is that I use the drop-down list to pick customer names, and have adress information automatically filled out throug a lookup.

Several of the cutomers has the same firmname, so therefor I need to have the drop-down list to also show adress information, so that I can do the right pick.

This information is used in a transport-registration layout, containing thousens of customers, whom some have several locations around the country.

I now an idea would be to have unique firmnames, but since we need to be hundred percent sure that we have the right customer, we prefer to do it the way I first described.

Chris

RE: Show more info in the drop-down list.

I would go for a conditional or a filtered portal.

With the conditional valuelist you can narrow down the choices, based upon the first valuelist (with 2 values, not more in FileMaker) and the second valuelist will show only the values that match the choice made in the first list.

Another option could be to make sure you have an unique identifier (not a meaningless) for each record and take this value as second field in the valuelist.

But usually I opt for a portal from where I can make a choice out of given values.
That gives a little more overhead to the UI, but with 1000+ possibilities it doesn't give much chances for errors.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close