From the course: FileMaker Pro 12 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating and applying dynamic value lists

Creating and applying dynamic value lists - FileMaker Pro Tutorial

From the course: FileMaker Pro 12 Essential Training

Start my 1-month free trial

Creating and applying dynamic value lists

In the previous movie we discussed creating a Static Value List that will contain a preset range of values. There is also another way that you can populate a Value List, and assign it to a Field Control on a field in a layout, and that is called creating a Dynamic Value List. Dynamic Value Lists are created on the fly based on data that is already in a field. If you remember, in a previous discussion, we have talked about how each field in FileMaker can have an Index. We can actually see that Index if we click inside of it, do Command+I or Ctrl+I on windows. So what this tells me is that out of all 146 records in the Invoice table that only one of these three Options shows up in any one of those fields. So it could be that there are 100 of them that say Pending and 20 that say Processing and 26 that say Shipped, but all FileMaker does is create a alphabetized and de-duped list of values in what's called an Index. So we can actually draw on this Index to create a dropdown Value List…

Contents