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.