472,096 Members | 1,312 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,096 software developers and data experts.

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


Jan 18 '07 #1
1 1748
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.