Drop List - multiple fields on list

[springguy]

In a desktop app, I have an entry field (Last Name) that uses a drop down box.  On the drop down list, I have the field that will be loaded into the target field (Last Name) when the selection is made, but also I have another field on the list (Home Address).  That second field is from the same file as the first field, but it is there to help the user discriminate between two entries in the list that had identical Last Names.

How do I include that second field on a Net Talk drop down list.  Again, it is just there for user info, it is not loaded into the target field.

Mike Springer

[bshields]

Hi Mike,

the SELECT control in HTML is pretty basic, but you can do lots of stuff via HTML.

What i do in your case (and its a compromise) is I calculate in the "Description Field:" of the "Lookup Setting" tab and often put the additional info in brackets or after a dash eg:

Daffy Duck (Works at Disney)
Road Runner (Works at Burger King)
Barack Obama (Unemployed)

So thats how i sneak two fields in one place.

Regards
Bill

[springguy]

Thanks Bill - that worked great!
You're terrific!
Mike