Looking for a nice tool

I am working on a web-based system where the end-user needs to be able to define the properties of a Widget (color, width, height, etc.) and then the user needs to be able add/edit/delete Widgets with the properties that were defined.

Take Homes for example: The user needs to define a Category named "Homes" and then setup the properties of a Home (Sq. Feet, Bedrooms, Bathrooms, Lot Size, etc). Now, someone can go in and start entering the homes into the site.

It would be nice if the system would:

• Allow for the creation of the widget structure as above
• Allow for searching for a widget (free text in Lot Size)
• Allow for a search to be narrowed by a property (only show homes with 3 bathrooms)

Instead of having a table for Homes and a table for Cars and a table for Network Devices, I want to have one set of tables hold Categories, CategoryProperties, CategoryPropertyValues or something like that.

I would assume that something like NewEgg or other sites like that are developed that way. It just seems crazy to create separate code for separate Categories of items.

There has to be something like this available, but I cannot seem to find the right words to use in Google to find it. It may be that one of the eCommerce solutions would allow this, but I am not overly familiar with them.

Can anyone point me in the right direction?

Thanks in advance!

Hey,

Have you had a look at the ASP.Net Starter Kits:

http://www.asp.net/community/projects/

They have a number of pre-built sites that may have something that covers what you are after.

It sounds to me like you are struggling with how the backend information is going to be stored, is that fair? If so, the best way to go about getting this sorted out would be to draw it out, just on a bit of paper, then start the normalization process, until you have got a structure that will cover everything that is required.

Gary

I know how I want the tables to be setup. I actually got started building it, but then thought that it should be something that already exists and stopped.

I did look over the Starter Kits, but didn't see what I wanted.

Hey,

It is unlikely that you are going to find something that fits your need EXACTLY, there is always going to some portion of it that doesn't quite fit, so you will either need to edit what you find, or start from the beginning taking complete control of it.

Gary