How to create value list w/ multiple calculations

[jschwarz]

I'm trying to create a salutation field which will be populated from a value list.

The options should be Mr. and Mrs. Smith, Mr. Smith, Ann and Mike, Mr. and Mrs. Mike Smith, etc.

What I have now is a value list from a field, which is a calculation based on the name and title fields. How can I make that value list more than one item long? I guess this is asking, if I'm doing this correctly, how do I make the field have several values?

If I'm not doing this correctly, what can I do instead?

[The Shadow]

Here's a simple example, creating a relational value-list based on a join back to the same table that computes the possible salutations in a field.

Was this what you're thinking of?

[jschwarz]

That's just what I wanted, thanks. What I was missing was using the paragraph symbol to denote separate entried.

One thing, however: is there any way to keep it from sorting the value list? In the calculation field, the entries are in the order I want, but in the popup menu, they're sorted alphabetically. I don't see where this option is stored.

[The Shadow]

One thing, however: is there any way to keep it from sorting the value list?... I don't see where this option is stored.

Nope, there's no *easy* way to control the order. Since you're pulling all the data from one record its using the index, so you get index order.

You could add a second field to order the result by, but then you'll need to split your calculation across multiple records also, which would be a major pain.