Hey Experts!! I hope everyone is having a great holiday weekend.
I have an intranet built on an Access 2003 database and classic ASP. I have been recently been asked to bulid a budgeting system. It consists of something like this:
The accessory table contains the pricing, while the other tables contain the client information as well as the product. The client can have more than one product. However, each product's pricing is set inside the table. So one client could have like 3 products with 3 different accessories. I need to be able to do a budget for up to the next 3 years for one client.
Bottom Line: 1 Client has 3 products with 3 different accessories. I need to do a budget for up to the next 3 years with all 3 products(no pricing) with all 3 accessories per prodcut.
I need to be able to have a form, filled out by the user for quantity and then multiplied by the price to give a total.
I hope I've explained that correctly. I just have NO idea where to start. Nor do I know how to do ASP calculations.