ISO FileMaker Magazine: FileMaker Video Tutorials, Templates, Help & More

Navigation

Video Browser

Scriptology Video Browser

Tools & Resources

Hierarchical Value Lists - (Dependent Value Lists)

Posted by: Editor / Monday, March 3, 2008 – 5:43pm

by Matt Petrowsky

27
 minutes

Knowing how to structure hierarchy, within data, should be one of your core pieces of know-how regarding data structure. Once you understand it, you can always leverage the knowledge for a variety of tasks. This structure applies to checking for sequential numerical entries (knowing when sequence is broken), generating a visual tree of levels and sub levels or storing a list of hierarchical value lists - most efficiently.

Building on a file presented in 2004, it goes to show that this basic structure for how data is stored does not change, nor is it likely to ever change. It's simply how you store data for hierarchy based information.

If, in your database, you need to present value list selections that hinge on each other then this is the video and technique file that you need!

Details: Released - 3/3/2008 / Size - 20.41 MB / Length - 27 min
About author

Matt Petrowsky is the Senior Editor for ISO FileMaker Magazine. Matt has been involved with FileMaker Pro since the early '90s. Having authored many articles, a popular book, spoken at conferences and seminars, as well as provided private training, Matt is continuously updating his knowledge and skill about the powerful FileMaker platform. You can contact Matt by sending email to editor@filemakermagazine.com.

Filed under: |
-
.

Custom sort order

.
.
.

Hi Matt,

I've followed this article with interest, how would you be able to apply a custom sort order to the values?

Regards,

Damon.

.
.

Pop-Up vs. Drop Down

.
.
.

Why don't drop-down lists work the same way the pop-up menu does with regards to showing only the value from the second field from within a value list?

It seems like "show only value from second field" should actually only show the value from the second field in a drop down just like it does in a pop up!

I tried using the technique file included here to test that theory, and was proven wrong. Now I need to find a work-around.

.

Be Notified!

Let us tell you when a new video is posted. We'll send you an email with a direct link right to your email inbox.
Make sure and whitelist (or add to your address book editor@filemakermagazine.com

Give your FileMaker interface a beautiful overhaul, make your layouts look great!Theme Box 150 Take control of your users' permissions using the Scriptology Permissions Template!Perms Box 150

iPod Video

Magazine IPod Small
Click to watch the video

FileMaker Reference Tool