Suggestions for a pricing matrix?
I've just purchased Filemaker Pro 11 and I'm running Windows Vista Ultimate. I own an independent sales representation firm with 2 additional employees, who work remotely. I'm new to database design and would like some help with this function:
I represent multiple companies, each of whom either manufacture or distribute multiple "brands". Each brand has its own set of dealer progams which utilize tiered pricing rules. To make sure the "sales order entry" form automatically pulls the correct pricing for each individual customer when we enter their order to the manufacturer, what steps should I employ to create low program overhead and most efficient use of the database. Feel free to ask any questions or point to information I may have left out.
With problems like this, it can be very useful to post an actual example of what you need to do here.