Hello. I am working on a Visual Basic 2005 Express app with a SQL Server 2005 DB. I have several basic tables in my DB, all containing student data for my school district. I have one table with all of the basic student info, including leave codes, which is a 2 character code that is pretty random (A1, C6, E8, etc). I have another table containing the leave codes as well as a description for each leave code that is linked to the student table by the leave code.
In my app, I have a form with all of the student data and the leave code field is a combobox. I would like the combobox to display the leave code and the code description separated by a hyphen and am not sure the best way to combine the two fields from two tables into a single combobox.
Maybe creating a view would work, but I am not sure if I would be able to save the data back to the student table if I used the view.
I am pretty stuck and not sure as to the best way to accomplish this task. Any help will be appreciated.
Thanks in advance.
In my app, I have a form with all of the student data and the leave code field is a combobox. I would like the combobox to display the leave code and the code description separated by a hyphen and am not sure the best way to combine the two fields from two tables into a single combobox.
Maybe creating a view would work, but I am not sure if I would be able to save the data back to the student table if I used the view.
I am pretty stuck and not sure as to the best way to accomplish this task. Any help will be appreciated.
Thanks in advance.