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

Posted on 2009-02-15
Medium Priority
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

Author Comment

ID: 23645287
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

ID: 23645297
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

Accepted Solution

Peter Harris earned 2000 total points
ID: 23666091
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

ID: 31547069
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.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Loops Section Overview
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

840 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