1 Reply Latest reply on Jan 14, 2013 3:23 PM by Stephen Huston

    relationships between databases

      I have a situation where 4 companies work together and are set up by one office manager in 4 separate FM databases. I'd like to create relationships between the databases without restructuring or changing to a model where the comanies are related within one database. Is this possible?

      One of the databases also has to be readable by an outside corp entity.

      I'm about to update their system from FM6 to FM 12 Advanced in the coming weeks.

      Any pointers in the right direction for the data model are appreciated.

        • 1. Re: relationships between databases
          Stephen Huston

          I am not sure what relationship structures you may need, lacking any idea of what you currently have in place, but you can do Record-Level locking of records for both editing and viewing within the Security/permissions settings. Each company's records would need a company identifier within the record which would be used to restrict company's users so each could see or edit only the records with their company ID, but it's all doable.

           

          Caveat: Is this is a good scalability idea? It may be useful with a single manager at this point, but at some point there may be good reason for the different companies to have separate file systems. Is it likely that more companies will be added who want identical functionality, or more likely that they are going to need to be reseparated down the road.

          1 of 1 people found this helpful