Master account w/ sub account numbers
We track client revenue with a SaaS and the revenue is associated to a client by account ID. However, due to the nature of our business model, we sometimes need to separate revenue for one client into...
Forum Discussion
You'll want to do what's called a 'circular relationship' or 'looping relationship' where you build a relationship with a single table. Essentially, you'll build a relationship where the Clients table is both the Parent and the Child, giving you the ability to have one account act as the Parent to other accounts.