rvfowler2

<div>
<div class="content wysiwyg-content fr-view">
<p>I don't like making value lists dynamic by using the field the value list is for because a) option won't show up if it's never been used before and b) sometimes we've changed the name in a value list and don't want someone selecting an old one (so wouldn't recommend changing names in a value list; gets to be a real pain).</p><p><br></p><p>QUESTION: &nbsp;How can you create a dynamic list, then. &nbsp;What I've done that works in several areas, is to create a table with only one record called PermGlobals and x relate it to say my PropInfo table. &nbsp;I do this for email addresses and it works great. &nbsp;It would work for most values lists, except in my case I want to separate the old ones from the new ones by adding in a ----OLD: and ----New: &nbsp; The only problem is that when a value lists uses a field it auto sorts alphabetically, so my Old and New values are mixed together.&nbsp; Any ideas?&nbsp; Thank you.</p>
</div>
</div>



I don't like making value lists dynamic by using the field the value list is for because a) option won't show up if it's never been used before and b) sometimes we've changed the name in a value list and don't want someone selecting an old one (so wouldn't recommend changing names in a value list; gets to be a real pain).
QUESTION:  How can you create a dynamic list, then.  What I've done that works in several areas, is to create a table with only one record called PermGlobals and x relate it to say my PropInfo table.  I do this for email addresses and it works great.  It would work for most values lists, except in my case I want to separate the old ones from the new ones by adding in a ----OLD: and ----New:   The only problem is that when a value lists uses a field it auto sorts alphabetically, so my Old and New values are mixed together.  Any ideas?  Thank you.

FM - How Can You Make Value Lists Dynamic and Sort How You Want?


I don&amp;#39;t like making value lists dynamic by using the field the value list is for because a) option won&amp;#39;t show up if it&amp;#39;s never been used before and b) sometimes we&amp;#39;ve changed the name in a value list and don&amp;#39;t want someone selecting an old one (so wouldn&amp;#39;t recommend changing names in a value list; gets to be a real pain).
QUESTION:  How can you create a dynamic list, then.  What I&amp;#39;ve done that works in several areas, is to create a table with only one record called PermGlobals and x relate it to say my PropInfo table.  I do this for email addresses and it works great.  It would work for most values lists, except in my case I want to separate the old ones from the new ones by adding in a ----OLD: and ----New:   The only problem is that when a value lists uses a field it auto sorts alphabetically, so my Old and New values are mixed together.  Any ideas?  Thank you.

FileMaker Pro is a cross-platform relational database application that integrates a database engine with a graphical user interface (GUI) and security features, allowing users to modify the database by dragging new elements into layouts, screens, or forms. FileMaker evolved from a DOS application, but since 1992 has been available for Microsoft Windows and Mac OS, and can be used in a cross-platform environment.