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 - FileMaker Pro Tutorial
From the course: FileMaker Pro 12 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.