Trouble with comboboxes
-
:wtf: Any help with this is appreciated VERY much. My trouble: I have a mini-CRM app that I am writing and I have a SQL database with multiple tables - Account, Region, etc. Each row in the Accounts row has an ID column that is the primary key and is auto-incremented. The same goes for the Region table. In the region table, each row had a region of the state (ie. Central, South). Let's say the table is as follows: ID Desc 1 Central 2 South On the form to create a new account, I want to display the Desc column values but insert the ID field into the Account table, so there is less data to store. I am trying to use a combobox to display all regions, and have so far been unsuccessful in inserting only the ID field into the Accounts table. I am using VB.Net, VS 2003 beta, and am using VS-created datasets and data adapters. Am I going down the correct path, or should I buy another book and read more. On the new Account form I have info from multiple tables with which I am trying to do the same thing, so I don't want to use a large number of datasets to store all data. Thank you all for you help. - Robert W. Dempsey