jmsinnz

Distributors that are also Customers - Best structure

Discussion created by jmsinnz on Jun 25, 2012
Latest reply on Jul 3, 2012 by Stephen Huston

I'll be as concise as I can, while seeking help to understand what the best table structure is for this scenario.

 

  • Distributors sell my product, and so do I. I am a Distributor.
  • Some distributors ask me to send the product to the end Customer, but they invoice them, and I bill the Distributor periodically
  • Some distributors ask me to send product and bill the Customer. Then I pay them a commission.
  • Some distributors buy product from me and handle their own sales.

 

So

  • One Distributor can have Many Customers
  • A Customer can belong to only One Distributor, but doesn’t have too.
  • A Customer can be a Distributor, but may not be

 

How can I use the Customer file to note all the contact details of Distributors?

EG Flag them with a Distributor Code (T/F) in order to get the REPORTS I need - primarily "Sales by distributor"

 

I am enoying coming back to FileMaker after a few years absence, but having been a long-time developer (of modest applications) since 1985.

Your help would be gratefully received :-)

 

James

--

Skype: jmsinnz

Outcomes