We currently have a database with uk customers in filmmaker. We now have worldwide offices and each dealer will be getting there own section to our filemaker.
The layout will stay the same. As the HQ we will have access to everyones customers. However the dealer in South Africa will only be able to see the ones in his country, Australian dealer see Australian customers and so on.
What is the best way to start.
Is there a was to give people privalidge to see only the country column in our database or would it require each dealer having his own table.