Thanks guys - perhaps if I give you the variables and the reulting lists I need? As follows:

Hospital List:
Fordingbridge
Hythe
Romsey
Gosport
Havant
Alton
Chase
Fleet
Odiham
Petersfield
Lymington
Abbey House
Brendon Care

I want the first item which appears on this first drop down list to say - 'Select Hospital'

Once a hospital is selected I then want the ward drop down to automatically populate with the relevant wards associated with the hospital selected, as follows:

Fordingbridge = Ford Ward
Hythe = Hythe Ward
Romsey = Romsey Ward
Gosport = Sultan Ward
Havant = Havant Ward
Alton = Anstey Ward, Inwood Ward
Chase = Macilwain Ward
Fleet = Calthorpe Ward
Odiham = Odiham Ward
Petersfield = Rowan Ward
Lymington = Deerleap Ward, Longbeech Ward, Wilverley 2 Ward, MAU Ward, Knightwood Ward
Abbey House = Single Rooms Ward
Brendon Care = Dame Sheila Quinn Ward

So, once a user selects, say, Lymington Hospital, the ward drop down immeidately changes to show all the Lymington Wards in the list i.e. Deerleap Ward, Longbeech Ward, Wilverley 2 Ward, MAU Ward, Knightwood Ward. If user selects Alton Hospital, the ward drop down immediately shows Anstey Ward and Indood Ward as the two wards associated with this hospital...and so and and so forth....

If anyone can help, would be much appreciated.