Hi Ron
”Can I ask that in the data structure is different with the new business? Maybe there’s any other solution will scale better."
The data structure is not so different, I could solve it by creating new columns. My main point is acccess permission, because I need only certain people accessing each database, but the main one is forms. I have few people filling these databases via forms. one column of this database is my projects, and I have many projects for each company.
when someone from company A is creating an entry via form, when they click on project, they can see all projects from company B. One way to solve it is to create two columns: one for Project A and other for Project B, but this is not scalable (maybe I’ll have company C and company D in the future )
I’ve created a topic asking for a filter in forms, but Fibery does not have it. I think the only way to keep privacy for both business is separating the databases.