Hi there, just wondering if there is anyone that can suggest what to do here. I am using a few Wrox books and trying to put this all together.

I have created a web site using DREAMWEAVER, ASP and a database in ACCESS.

I am realy having problems with the database design.

So far I have created the following tables. I have left a few fields out as they are not neccisary in this email.

* tblSpecies - idSpecies & Fruit Type

* tblFinishes - idFinish & Finish Type (Meaning Smooth or Waxed).

* tblLocation - idTown & Town Location

* tblMoisture - idMoisture & Moisture Content

* tblSuppCategory - idSuppCategory & Supplier Type

* tblSuppliers - idSupplier & Name & Address & Phone & Fax & Email & Website & Description

From there I have created a search, results & detail.asp pages.

I have been told that in ACCESS I need to create another table that will put all of these together.

I would like to login to the search page and search the following. For these I have created search field for species and drop down menues for the rest.

(APPLE) (WAXED) (NSW) (2 deg) (FRUIT)
SPECIES - FINISHES - LOCATION - TEMPRATURE - CATEGORY

With this search i would like to see the results of all the suppliers that have APPLES in stock which have been WAXED and are located in NSW with a temp of 2 deg and are categorised as FRUIT.

The part that has puzzled me for so far is that 1 supplier has 50 differednt SPECIES. Another supplier may also have the same 50 SPECIES.

Would appreciate any help here. Have been lost for a while now. The more I think about it the more i get lost.

Thanks

MALHYP.

Sounds like primary key and foreign key relationships have not been set. Have you set up the relationships between the tables?