: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

Hello everyone, I am a newbie and I am hoping that you all can help me with a little trouble I am having. I have a VB.NET CRM application that I am writing for my company. I am using a MySQL database to hold all of the data. The app is a windows form application which will be installed on everyone's computer in the office. I need to be able to authenticate the user from a list of users in a db table (which I can do no problem) but I am getting stuck on how I can keep the user's logged in status so that I can record (in another database table) the actions they perform in the system. I appreciate any and all help and advice that you can give me on how to do this. Have a great day. Sincerely, Robert W. Dempsey