Show more info in the drop-down list.

[caman74]

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

 

[JeanW]

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.