Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Assign textvalues to the different selections of an option group

Status
Not open for further replies.

Swamphen

Programmer
Jul 17, 2001
84
IT
Hello,

I hava a database built by a form.

In that form I hava a few option groups, for instance:

--------------------
Riverwidth |
|
* uniform |
|
* variable |
--------------------

If one enables the radiobutton next to "uniform", the database stores the value 1. If "variable" is selected,
the value 2 will appear in the database.

I would like to read in the Access table from a Java program and I would not like to manually type in the different possibilities for each option group (like: if (value == 1) riverwidth = "uniform";), since this is not a very professional way to do it.

So, my question:

- can the value stored in the database be changed to "uniform" or "variable" (for the shown example) without having to re-enter all the records.

- can the value be derived from somewhere within Access. And
this without making a new table for each option group showing the different possiblities (I know this is a fairly
good solution, but for reasons I'm not getting in to here I can't use that solution at the moment).

Many thank you's,

Swamphen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top