There is a one to many relation for customers to accounts, but only a one to one relation between accounts and categories? What is the use of this, I want to set up a structure like
Customers has many accounts and account has many categories (f ex Build cost vs Run cost) I then want to be able to separate the build and run cost per account, but currently the only way to do this is create 2 separate accounts with same description and different category which then will not be summed up at account level as they are split. Any way to solve this,