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]

Hello Paul,
Thank you for your response, it does make sense what you have said and is exactly what I would like to do with the software. However I can’t find the area in which to enter the formula fields? Below are the steps I normally take to create a drop down box can you advise me on the additional step required.
Option 1,
1) Developer tab (click) drop down list drop down tab created (do I need to create a combo box instead?)
Choose an item.
2)click properties entre relevant information click ok and the drop down box is created.

Option 2,
Create a drop down form field in the legacy tools.

Then select properties a tab comes up that looks much more like the area I should be in however when I press F9 the brackets do not create.
Any additional help would be really appreciated
Regards
Tom