Thread: Using Java CheckBox to insert data to MSAccess Database

Hello!

I'm using Netbeans 7.0 to develop a programme to Insert data into a MS Access database.

It has 2 tables Main and Col

Main table have 2 fields (VID and Name) - VID is the primary key
Col table have 2 fields (VID and Color) - Have composite key(Both VID and Color)

My program is now able to add all 3 fileds via it's UI.
I have 3 colors in 3 checkboxes, now it is only capable of
adding only 1 color at a time. When I select more than 1 color (2 or3)
it's not working.

ex: when I select 2 colors form my interface and Insert it,
I need to appear it like this in my Col table

VID Col
37 Red
37 Orange

Note : both VID and Col are composite keys


need yo kind help!
Thanx 4 reading