Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
ad_dogg
Starting Member
2 Posts |
Posted - 2006-08-07 : 11:20:08
|
Hi, i have created a database in VB05, i have a form and a few combo boxes. I am a total newbie to this so i only know the total basics.two tables i have are Ratings and films.Ratings:RatingIDRatingFilms:filmIDTitleratingIDabove are the columns of my tables.what i am trying to do is select a rating on the first combo box which will then only show the titles with that rating in the next combo box.I have the whole database created, i have the relationships in place and the combo boxes are all connected to the datasources etc. The comboboxes are currently filled with data by the default sql query which is created. But it is showing the whole data for each when i only want to show the film titles for what rating is selected.Could any one please help. |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-08 : 01:39:10
|
What front end Application you are using?well, it will be better if you can fill the Film combo box, on the SelChange Event of the Rating Combo. The Query to fill the combo should look somthing like this. Select F.Title From Films F Where F.RatingID = <RatingCombo.Text> Chirag |
|
|
ad_dogg
Starting Member
2 Posts |
Posted - 2006-08-08 : 07:23:52
|
Thanks, i'll try this. Im using visual basics 2005 express for everything, so im using there built in databases etc. |
|
|
|
|
|