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