I have a list of products, manufacturers & customers
manufacturers can choose which products to offer
Each manufacturer sets their own price for the products and have their own shipping requirements
Each manufacturer has a territory (defined list of customers)
I have an order form template available in Excel
Database needs:
generate a separate order form for each manufacturer - form must resemble Excel template I've made
form for order entry
store unique customer orders
Ability to generate various reports for unique orders and product sales