469,323 Members | 1,412 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,323 developers. It's quick & easy.

MySQL Structure

I am new to DB's and have a problem. I think i am missing a principal method which is creating a problem. I am using a Store location DB which is loading into VB. The basic structure is as follows.
StoreID(Primary), StorIdent(Holds Store Identifier ie.CDN01), Name(Store Name)
Address, City, PC, Country, Phone.

In my programming on formload I am loading City into ComboBox 1. If I look at city as an example in combo box 1 there are let's say 3 toronto's, 2 bramptons. They correspond to the city's in the Store Location DB. I just want toronto to show once and brampton to show once. As they drill down they will select store name in a secondary combo box. Again the same store name shows up multiple times because the same name is in the db with different locations. Is this a problem with the way the db is designed.

Hope someone can explain

Thanks

Robert
Jan 18 '07 #1
1 1724
ronverdonk
4,258 Expert 4TB
Use the SELECT DISTINCT col_name FROM ..etc...in your query.

Ronald :cool:
Jan 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by Kumar Saurabh | last post: by
39 posts views Thread by windandwaves | last post: by
2 posts views Thread by csgraham74 | last post: by
4 posts views Thread by Vanessa | last post: by
reply views Thread by ansuhua | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.