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
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"
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