Saturday, December 5, 2009

QuickTip: Creating a drop down list from an unstored calculation

The following technique is a quick tip, which may be known by some, but I needed it so many times in our current development that I thought I would share it.

If you have ever tried to create a value list from an unstored field, you may have noticed the following error message that filemaker gives you:


This means that our value list based on this calculation won't work.

What can we do now? Don't give up!

It's really simple.

If you have an ID field in your table (auto enter, serial), create a relation based on this field to itself like this:

(ID=ID)
The next thing to do is to modify the value list, so that it only includes values from this relation:

If you press OK now, you will still see the error message appear, but the value list will work now.


Please visit our site, http://crm.fm which has our main FileMaker product, and support us by buying it. Thanks!

The material on this document is offered as is. There is no representation or warranty, expressed or implied, nor does any other contributor to this post. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

1 comment:

  1. Great Tip - Thanks! I don't understand why FM makes this so difficult, since it is such a common thing to do.

    ReplyDelete