Do combox and radio button store only numeric value?

[eujeong]

I would like to store the string in my table when I choose a string from a combobox or radio button in the form.
For example, if I choose 'Business' ( from major field in my department table ) in my combobox, I expect there is a 'Business' in my major field in my department table. And if I click radio button labled 'A' (position field), I expect there will be 'A' in the position field in my table.
However, those only store numeric values, for example '3' for 'Business' and '1' for 'A' in the table. How can I store the 'real value' in my table instead of number when I choose them.
Please help me out!!!

 

[Mihail]

I would like to store the string in my table when I choose a string from a combobox or radio button in the form.
For example, if I choose 'Business' ( from major field in my department table ) in my combobox, I expect there is a 'Business' in my major field in my department table. And if I click radio button labled 'A' (position field), I expect there will be 'A' in the position field in my table.
However, those only store numeric values, for example '3' for 'Business' and '1' for 'A' in the table. How can I store the 'real value' in my table instead of number when I choose them.
Please help me out!!!

Fortunately, Access know DBs . It (Access) do a well job.
Regarding you... you must learn.
Start here: Database Normalization and Table Structures - Microsoft Access / VBA.
If you will understand this, you will understand why Access store that numbers.

Warning: You will never be able to create good DBs without to understand the concept of NORMALIZATION.

 

[eujeong]

Fortunately, Access know DBs . It (Access) do a well job.
Regarding you... you must learn.
If you will understand this, you will understand why Access store that numbers.

Warning: You will never be able to create good DBs without to understand the concept of NORMALIZATION.

Thank you for your quick response. I read the posting that you linked.
However, I still don't understand why it returns numbers. yes... I am a novice on Access.:banghead:
Let me explain more detail.
I made : tblDepartment, tblDivision, tblStudent ( it includes department and division field. if i don't include those fields, Access ask me 'parameter' for department and division when I open my Student form) and frmStudent.
I made combo boxes for Department and Division in my Student form.
On that form if I choose department and division, Access store the ID number of department and division on their field in Student form.
I think I made a mess in some point.... but I can't find any clue....
Could you please explain what is the problem of my database?

 

[Mile-O]

Radio buttons simply have a numeric index value. They won't ever be text values.

Sounds to me like the Department and a Division fields in your Student table are Text rather than Numeric. That you have a table each for Department and Division suggests you are halfway right to normalisation up want to consider an autonumber key in them, and then, rather than have a combo and some radio buttons, two comboboxes, with each offering queries on Departments and Divisions respectively.