ASP and SQL Server 2000
DATABASE
Clienst Table
Products Table
ClientsAndProducts Table
I want a searche page that can search on a clients name or on a productname.
The client search is done in a textfield(fuzzy) en de productname fields must be drowndown (select) filed with the product from the Products Table.
If the visistor searched on clients then the resultpage shows a list of the clients found and when the click on one of the clients found there shoud be a detailpage with the client and his products (they can have more than one product!)
If the visistor searched on products then the resultpage shows that product and all the clients that bought that product.
The visitor must also be able to edit Clients and the Products the buy. So there should be a page where the can select a client (after a search) and insert a product (from a dropdown select field). I suggest that it should be saved in the ClientsAndProducts Tabel.
SEE ATTACHMENT FOR TABLES DETAILS!
I've alreay build pages for adding and editing Clients and Products so far.
Hope you can work with this info.
## Deliverables
Working ASP Pages including commenttags for futher editing.
## Platform
ASP and SQL Server 2000 on Windows 2000 server