AnsweredAssumed Answered

Suggestions for a pricing matrix?

Question asked by tacostrat on Apr 12, 2010
Latest reply on Apr 12, 2010 by philmodjunk

Title

Suggestions for a pricing matrix?

Post

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.

Thanks,

Tim

Outcomes