Dynamically adding value to value list

[raveldc]

I have an address book, with two related tables. In each of the related tables, I have a value list populated by a calculated field in the AB table. Is there a way to have the drop-down list populated in the related tables, but then allow editing of the value list with a new value if entered by the user?

[Lee Smith]

Take a look at the options available when setting up your field with a Value List. After selecting the type of menu you want (i.e. Drop down list, Pop Up Menu, etc) two additiona boxes show up, one is the "Include Edit"

HTH

Lee

[LaRetta]

I have a value list populated by a calculated field in the AB table.

If the value list is based upon field values from the AB table (which it appears to be) then you need to select 'Other' for popup menu (or just type new different value in popup list) to add a new item. When a new value is placed within the field, it will begin to display as a VL selection item. BUT ... the field in which you add the new value MUST reside in the AB table because that is where it derives its value. You simply can't add a new value to a field-based value list from another table.

If you use Custom value list, you have no such limit (and you can allow edit of the value list as Lee explains) but you must hard-code each value. You can combine two value lists into one (one VL based upon field values and other based upon Custom values) by using a calculation which combines them but IT can't be used as a value list because it must be indexed and can't be indexed if it contains a field or value based upon another table. Well, it can ... but it will never refresh. Catch-22.

There is however a third option (see attached). Users can select from values obtained from the AB table (just by clicking the field itself) or select custom value (in which they are allowed to edit) with 'non-field' values. The same text field is used with different value lists attached except turn off 'Allow Entry' on the invisible Custom VL field. The text field with the Custom values is 1 px higher than the visible field (67 px down from top) whereas regular field is 68 px down from the top. I made it 1 px higher only so everyone could find it easier. No - both field values and custom can't display and update in ONE value list but this is another option.

LaRetta :wink2:

AB.zip

[Lee Smith]

Good catch LaRetta, I missed the "Calculated" part.