Access Database (assembly/recipe)

I'm a Plumber, when quoting I use "structures" to build up my quote. One metre of pipe has labour, pipe, solder, clips, ect. The materials name and price is drawn from a price file from my trade suppler, there are smaller suppliers of products that I use and labour too. Ability to add new suppliers to their own table as the main price disk gets updated each month In Access I want to be able to build these structures, some structures are made up of multiple structures. Then use these structures within Access to quote my jobs. ![][1] Above is how I do it at the moment. This is one structure and shows you the fields I need. Structures are divided up under different headings, drainage, roof, copper pipe, sewer, stormwater, etc etc Once my structures are input I want to be able to call only the structures in need for the particular quote, up within a quote add the number of metres for each structure to the quote and then add the % mark up profit and % for tax (default 10%) print an itemised report with all material totals and the costs. Each quote needs customer name, address, phone, quote date and individual numbering as well as the costs and materials. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP using MS Access 2000 or 2003