I'm using FMP10 Advanced
We're on a FM8 Server.
I have been tasked to join two separate database files.
One is a SCENE database.
The other is a DESIGN database.
The common hub is an EPISODE table that each file contains (which uses duplicate information in each file.)
What is the best, and safest, way to do this?