Value list from field AND static list

[Xetabase]

Filemaker currently allows a value list to be determined by a table field, OR by a static list.   There should be an option to create a value list from a table field AND a static list.  This would make it easy to add choices like ALL, NONE, etc.

[bcooney]

None?

[David Jondreau]

There is a way to do this. The cool kids these days are using ExecuteSQL() and virtual lists to create value lists on the fly. Check out this website: www.filemakerhacks.com.

[bcooney]

The "cool kids" - love that, David!

[LaRetta]

The easy way is to create a calculation and use the calc instead ... Simple, easy ... for example ... If your value list is based on Status, the calc would be Status & cr & "-ALL-" replace cr with a real pilcrow

[LaRetta]

BTW, I see a place for 'none' also at times Barbara. If you are using a pop-up or radio button and User changes their mind, a None provides an option since they cannot 'unselect' or *clear. Many times it is important also to distinguish between User skipping a question (null) versus set to None.

* and yes you can remove values by shift and there are other tricks but None is more User-friendly. :-)

[bcooney]

Got it, thanks, LaRetta. Perhaps that is what he meant by "None."