Hi everybody,

First of all, is ASP forum dead here? I asked one or two questions so far, but got 0 response.

I have a task of designing a small new application for the WEB from the beginning to the end.

The data could be described this way:

Category (so far, we defined 3 category, but we may add one or two more)
Address part - all records have them
Date - (in our system different categories have different field for this)
----------------------------------------
Now for each category of data there is a set of fields (properties), which define this category.

=============================
In our system, written in Visual Foxpro, we have one table, which describes all data (all types) and several Lookup tables, used to expand coded fields.

I need to organize this on the WEB. I need to be able to search by address, by date, by category (but may search across categories) and by name [we have 5 name fields - for category one only one name is used, for two other categories we may have up to 5 names - different fields]

I'm thinking about this model:

   MainInfo table - all records
   ID                        
   Only Address Part
   SearchDate 
   Name1 - exists in all categories
------------------------------------
   Category2 table 
   ID
   Additional fields
   Coded fields expanded 
------------------------------
   Category3 table
   ID
   Additional fields
   Coded fields expanded 
---------------------------------
   AllNames
   ID FirstName LastName NameDescr

--------------------------------------
This means, I will need several recordsets returned, if I'm searching in all categories.

------------------------------------------------------
What do you think? I'm also considering one flat model, as we currently have.

The table currently has 750000 records with ~100 - 150 records added each week.

Thanks in advance.