Hi Thomas,

Unless you need to be able to select a different phone # than the one determined by the name, there's no need for the second dropdown. All you need is a set of ordinary formula fields coded along the lines of:
{IF{REF Dropdown1}= "1stname" "123456"}
{IF{REF Dropdown1}= "2ndname" "234567"}
{IF{REF Dropdown1}= "3rdname" "345678"}
and so on, where 'Dropdown1' is the formfield's bookmark name (found via its 'properties - which you also set to 'calculate on exit') and 1stname, 2ndname, 3rdname are the actual names and the number strings are the phone numbers.

I've put all the fields on separate lines for clarity, but you can have them all on the same line - the fields for which there's no match simply won't display.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]