Yes, it is how it should work, but the dilemma is now with 2 seperate locations, with their own respective back ends.
Location1 has it's own data, it has a sale and the ID is 1. Now Location2 does a sale and it's ID is 1. Whilst you can seperate the Sale tables based on their location, the...