Hi, I'd like to ask for help about Access, ASP - all this is new for
me...
I'd like to make an Access based website for searching, comparing and
adding some electrical appliances. These appliances are supposed to
have a lable name, type, serial number and they also have some
options. (Just like cars: volvo, s80, color red, airco).
My question is about the structure of the database: is it better to
store for example the "colors" in a separate (related) table in Access
or to have one table for everything and use the lookup option with
dropdown menu? Can I connect such a dropdown list from the lookup in
database to the website using ASP? And if some options have options
themselves (like manual airco/automatical airco), what is the best
structure for it?
The final product must be a site where new models can be added and
available appliances can be searched and compared.
Thank you for your help,
Alex