Philipp Matuschka 1/28/2019 4:40:10 AM
Another approach here is to actually have all your clients in one database and have an additional column by which you control access. So I have a column called Record Access Client ID in every table and every Record Access Permission incorporates this as part of it's access rules.
Each user has a column in his User Settings which links him to a particular client and every time he creates a record the column Record Access Client ID is populated from his User Settings column.
You can then get more sophisticated and link a User to multiple Clients and let him select which one is "in Context" at any particular time. It takes some careful management, but I have been running it for 3 years now without an issue. The advantage is that you DON'T have to go and update your 18 clients afterwards.
I know that there is at least one other developer doing this and I have even had a long Skype conversation with him. I am just having a complete memory lapse as to his name at the moment. Farm machinery in the US is his business.