471,356 Members | 1,638 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

database Question..


hi everyone..

i have a situation, there are two drop down list, 1)Car Model 2) Car
Colours. A set of specific colours would fill up the second dropdown list
based on the Car Model choosen on the first drop down list.

my question is how do i create a database table that enables me to
extract the specific colours based on the car model chosen?.How to create
database to accomodate this kinda specific info?

hope to get some feedback here.thank you.
Jul 21 '05 #1
2 1042
Of course a relational database like MSDE would do, but I suppose that's
oversized. If there are just two tables which do not change I would use an
XML textfile like
<car>
<model>xyz</model>
<color>pink</color>
<color>blue</color>
</car>

It's not very sophisticated but probably the fastest solution.

"dcinfinite" wrote:

hi everyone..

i have a situation, there are two drop down list, 1)Car Model 2) Car
Colours. A set of specific colours would fill up the second dropdown list
based on the Car Model choosen on the first drop down list.

my question is how do i create a database table that enables me to
extract the specific colours based on the car model chosen?.How to create
database to accomodate this kinda specific info?

hope to get some feedback here.thank you.

Jul 21 '05 #2
DCInfinity.

I assume you want to have a limited table with colors, therefore why not
just in the database as a simple table. It is than simple to maintenance
because it is in one database.

Be aware that when you use this in a combobox, to set the comboboxstyle to
dropdownlist style. Because when the colors can be edited with this, than my
expirience is that it surely goes wrong in VS2002/2003.

I hope this helps?

Cor
Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Inspector | last post: by
5 posts views Thread by Slant | last post: by
reply views Thread by XIAOLAOHU | 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.