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.