Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Distributors that are also Customers - Best structure


Recommended Posts

I'd love some help to understand what the best table structure might be 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.



  • 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

I am wondering about the wisdom of using the Customer file to also record the contact details of Distributors?IE Flagging them with a Distributor Code (T/F) in order to get the REPORTS I need - primarily "Sales by distributor"

I'm enjoying coming back to FileMaker after a few years absence, but having been a long-time developer (of modest applications) since 1985. Any help or pointers would be gratefully received :-)


--Skype: jmsinnz

Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use