We have server A (current work data) and a server B (Archive data), both FM Server Advanced 11.
Table Invoice on server A has imported invoice numbers (e.g. 10000 numbers, changes every day) from the work data and archive data.
There is a relation ship to server A and server B with the invoice number.
In a script 'amount' there is a loop, where we sum the amount of the invoices per date, some are in work, some in archive.
This works fine on a client, but we want to run it on server site, resp. call the script from php.
But it won't work, the server A only see his own database.
Does anybody knows a workaround? Or had the same problem solved?
Thanks for help.