Concatenate value lists?

[wintergreen]

Is there a way to concatenate 2 value lists?

For example, I want to have one value list derived from a field (call it "account name")

Then I want to be able to append a value list with hard-coded values, such as "Add new account…"

The only place I want this for is on a popup menu on a layout.

The only way I can think of is to create a dummy record with the hardcoded value, but then it'll have to be hidden everywhere else, which seems like rather a lot of work.

[TheTominator]

Create a (stored) calculated field in the same table as "account name" that consists of

account name & "¶" &

"Add new account..."

Append as many new entries as you want on new lines.

Use this field to generate your value list instead of "account name".

Edited November 23, 2009 by Guest

[wintergreen]

Thanks Tom (sorry it took me so long to post a reply…)

Also discovered that this is possible quite easily via the ScriptMaster plugin.