database Question..

[dcinfinite]

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.

[Schmeusser]

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.

[Cor Ligthert]

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