Filemaker - How do I create a multiple column drop down list

Posted on 2009-02-15
Last Modified: 2012-08-13
how do I construct a multi-column pop-up list. All I want to do is create a pop-up that displays First name, Last Name and probable Client ID. Client ID would be the field that gets saved but obviously I want to display full name in the pop-up list. If name is concatenated, even better.
Question by:c0link

    Expert Comment


    Author Comment

    Cannot see what web development has got to do with Filemaker Pro question. This does not appear to relate to my question at all.
    LVL 28

    Expert Comment

    you can only use 2 fields, so you must put name and firstname in a common field to achieve this or skip firstname, or use a calcculated field for name+firstname
    LVL 5

    Accepted Solution

    In the table that provides the data for your pop-up use a calculated field which concatenates the fields you want to appear
    FullName = FirstName & " " & LastName

    So on the layout where you are choosing the name you have the ClientID field and the Fullname field (which comes from a relational link with the Client table with ClientID as the key).

    You can make the clientID field (which has the pop-up set for it) covers the FullName field if you want.
    Then set the options so that the FullName is not enterable in browse mode so that only the pop-up appears when they click on it.

    Author Closing Comment

    had similar solution previously but thanks for input. I had in fact tried this before asking the question but for some reason it did not work. Think it might have been because data type was set to number in calculation, instead of text. Works now, thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now