is it possible to create a dropdown field. the posts ive read here so far a very confusing. Is there a straight forward approach to getting this done

You add an Enumeration field and add your dropdown selections to it.

Or a joined data. (2nd level in the fields tree)

"Or a joined data. (2nd level in the fields tree) "

Would you mind explaining? I'd like to use a drop down list which is populated from another table.

is this possible?

thanks,
Geoff

You can do this with a 'Foreign Key'. For example if you have an Address table and a Cities table, add a Foreign Key data type to the Address table and drag and drop the Cities table onto it. On your page you can add the Foreign Key field and it will be displayed as a drop-down list of cities.

Is this what you were looking for?

Yep, got it. Works great, thanks again!

regards,
Geoff