Click here to Skip to main content
11,484,162 members (72,446 online)
   

Java

 
QuestionJCOMBOBOX Pin
Chrisloys4-Dec-12 3:40
memberChrisloys4-Dec-12 3:40 
AnswerRe: JCOMBOBOX Pin
Richard MacCutchan4-Dec-12 5:52
mvpRichard MacCutchan4-Dec-12 5:52 
GeneralRe: JCOMBOBOX Pin
Chrisloys4-Dec-12 6:36
memberChrisloys4-Dec-12 6:36 
GeneralRe: JCOMBOBOX Pin
Richard MacCutchan4-Dec-12 6:58
mvpRichard MacCutchan4-Dec-12 6:58 
GeneralRe: JCOMBOBOX Pin
Chrisloys4-Dec-12 7:04
memberChrisloys4-Dec-12 7:04 
No the numbers are not random per say they are developed by mysql as they are autonumber/primarykey. So if we had two customers with same name they would have two differnt ids. I need to reference this id from the combobox to correctly populate the table.

So my table will look like this
id customername address city
1 customer1 123 this st atown
3 customer2 5 that st btown
4 customer 3 989 overhere st ctown
2 customer 4 9999 overthere st dtown
6 customer 5 234 thisstreet st e town

So when the user selects customer2 from the combobox it will in turn say customer2's id is 3.
3 will then be used to query the customer information and display this in the table.

I hope iam explaining this correctly... this was very common in ms access but all i had todo was hide the column with the id so it only displayed the customer name. When a new customer was selected it would take the hidden id column value to populate a table. It was extremely easy.
GeneralRe: JCOMBOBOX Pin
Richard MacCutchan4-Dec-12 7:10
mvpRichard MacCutchan4-Dec-12 7:10 
GeneralRe: JCOMBOBOX Pin
Chrisloys4-Dec-12 7:12
memberChrisloys4-Dec-12 7:12 
GeneralRe: JCOMBOBOX Pin
Richard MacCutchan4-Dec-12 7:34
mvpRichard MacCutchan4-Dec-12 7:34 
GeneralRe: JCOMBOBOX Pin
Chrisloys4-Dec-12 7:41
memberChrisloys4-Dec-12 7:41 
GeneralRe: JCOMBOBOX Pin
Richard MacCutchan4-Dec-12 7:44
mvpRichard MacCutchan4-Dec-12 7:44 
GeneralRe: JCOMBOBOX Pin
Chrisloys4-Dec-12 7:47
memberChrisloys4-Dec-12 7:47 
GeneralRe: JCOMBOBOX Pin
Richard MacCutchan4-Dec-12 8:24
mvpRichard MacCutchan4-Dec-12 8:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 23 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid