Below is a picture of my current model which works fine for one company. I now need to create a P&L which stretches across four companies, combined. The problem here is that I could have one account number, say 455000, but that could mean “Rent” for company one and “Electricity” for company two. In other words, I can no longer simply rely on a “Accnumber” relationship. I need to now rely on a “Company Accnumber” relationship. Is it really as simple as creating a new “merged” field in my two tables called “CompanyAccnumber” and then defining my relationships off of this? My company names are quite long, to give you an idea: XXXXX XXXXX XXXXX (PTY) LTD.
Is this the best practice way, or is there something better I need to consider?
As always, thank you.