SQL table with a choice list (in pure SQL or with Java) -

i willing create myself table in database make. don't know how create choice list fill fields.

i explain problem more specifically. want obtain this

...................................................... table employees (just example) ....................................................... index / name / profession

1 / john / manager ..........<= here choice list between possible jobs have

how can this? want employee table editable (like in gui interface in java), , values of profession can edited (meaning, can select different value choice list).

many in advance help!

tom

i recommend have 2 tables in db. 1 employee , 1 jobs.. in ui (java) have business populate drop down jobs table.. when save ui info have write in both tables if necessary.

e.g. employee table: id, name, job_id , job table id, name. need 2 methods 1 read employee , 1 read jobs. dropdown have 3 properties: id (id job table, display - name job table , binding value - job_id employee table) drop down should have options add new values.. when save in db if have new values in job have add values in db , link employees