By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,820 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,820 IT Pros & Developers. It's quick & easy.

advise about STRUCTURE for a beginner

P: n/a
Hi, I'd like to ask for help about Access, ASP - all this is new for

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,
Feb 8 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.