Asp Driven access database inventory control

A simple access database project using asp pages for adding or retrieving information from database The complete inventory control must have the following abilities Products database must have several custom defined fields ( a complete list will be supplied ) including the ability to store links for up to 10 product pictures, and drop down lists with several pre-defined categories for products, product location etc Incoming parts database related to parts by a single field Outgoing parts database related to parts by a single field A data entry form will give user the ability to perform a search for a product using different search criteria like partname, partcode, description, equipment used in, etc, if no part is located using these criteria the software will give user the ability to add the product by opening another data entry form, in that form and once all fields are complete, form contents will be validated for correct entry, and then user will be asked to have the product entered in the products database or not In case the product was found, a scroll down list containing the search results indexed by the search criteria used will open and user must be able to click on any product to view the products detailed page In each products detailed page selected fields will be displayed including all product picture thumbnails with the added functionality to click on any thumbnail to see a high resolution picture, user must have the option by using a function key or a menu selection, to see separately all incoming ??" outgoing traffic for the selected product, like dates purchased, or sold, prices, purchased from, sold to, qtys etc Once a product has been created in the main parts database, user must have the ability by pressing a function key or a small selection menu to enter incoming our outgoing parts, and software will have to keep the main products database at correct level by adding or subtracting qtys, while the 2 separate incoming ??" outgoing databases are correctly updated with all entered and validated details A customer database can be related to incoming and outgoing products, providing a simple way to see customer performance and vendor performance as well