Click here to Skip to main content
   

Java

 
AnswerRe: JCOMBOBOX PinmvpRichard MacCutchan4-Dec-12 5:52 
GeneralRe: JCOMBOBOX PinmemberChrisloys4-Dec-12 6:36 
GeneralRe: JCOMBOBOX PinmvpRichard MacCutchan4-Dec-12 6:58 
GeneralRe: JCOMBOBOX PinmemberChrisloys4-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 PinmvpRichard MacCutchan4-Dec-12 7:10 
GeneralRe: JCOMBOBOX PinmemberChrisloys4-Dec-12 7:12 
GeneralRe: JCOMBOBOX PinmvpRichard MacCutchan4-Dec-12 7:34 
GeneralRe: JCOMBOBOX PinmemberChrisloys4-Dec-12 7:41 
GeneralRe: JCOMBOBOX PinmvpRichard MacCutchan4-Dec-12 7:44 
GeneralRe: JCOMBOBOX PinmemberChrisloys4-Dec-12 7:47 

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.150327.1 | Last Updated 28 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid