Distributors that are also Customers - Best structure

[jmsinnz]

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.
  

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
  

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 :-)

James

--Skype: jmsinnz