Is it possible to do the following.

I have two text fields on my form, one named text5 labelled 'Home Team', another named text6 labelled 'Away Team'.

I would like a drop down labelled 'Result' which would have the options

text5 Win
text6 Win
Draw

Hope this makes sense.

Hiya Mike,

This is definitely possible, just add the drop down element and then when you edit the settings for it create those choices in the drop down list. Delete the original drop down list items that were there and you're all set.

OK, so drop down 1 has all the team names, drop down 2 has all the team names then drop down 3 says home wins, visitors win, draw. then selecting the team names, and result then submit it all gets entered into your database.