bigtom

ODBC with two other databases.

Discussion created by bigtom on Jul 2, 2014
Latest reply on Jul 5, 2014 by usbc

I am setting up a connection between Filemaker and two MySQL databases. Filemaker is generating new records and some fo the record data goes out to MySQL A and some goes out to MySQL B. Some of the data is shared between A and B. When a change in this shared data is made in any database those changes need updated in all locations.

 

Can the two external databases be related directly in the relaitonship graph? Should I really just relate the two of them individually to two occurances of the Filmaker table.

 

I will have to keep trying stuff to see how it works, but any advice is appreciated.

Outcomes