Filemaker Go won't show related field when called from script

Title

Filemaker Go won't show related field when called from script

Post

I Have a database hosted on FM server 11, build with Filemaker Pro adavanced 11. I made a script to send e-mail with a specific text message and subject. Those Message and subject are field in a related table. In the send e-mail step of the script, the subject and message are calculation that refer to those field. Here an example with the Maintable and the Emailtable:

In Maintable, send e-mail using specific SMTP, the e-mail adress came from field : Maintable::eMail, the subject came from calculation : "blablabla "& Maintable::xxxfield & Emailtable::Subject, the Message came from caclulation : "blablabla "& Maintable::xxxfield & Emailtable::message

The script work perfectly on my mac with Filemaker Pro 11 (in fact on 2 different mac), the message is sent with all the information.

But on the iPad, all the Emailtable field are not in the e-mail. Other than that the script act exactly as on Filemaker Pro.

I am unable to replicate the problem. First, I don't have access to a SMTP server from my iPad, as our mail server does not accept outside connections. When I try, i get "The connection was refused by the SMTP Server". If I change this from SMTP Server to E-mail client, the related fields are being included. Can you verify? If so, I'll try to get access to a mail server that accepts outside connections.

I tried to replicate the problem on a fresh new database with only the steps in the previous post, and it work properly.

So here's some specific thing in the database that has the problem.

First of all some data are copied from an MySQL database linked true ODBC driver from ActualTech to this database as a read only access. Filemaker created 4 new tables from MySQL database and the relationship work properly. My script does not include any field of those related database.

The database as several Print and screen Layout based on the platform used. Most of them are to create PDF.

The eMail Table as 8 records and each record contain a serie of message used on specific Layout all in 2 languages.

As I told you before, all the steps calling any of the eMail Table Field on the Mac work as expected, but on the iPad, none work when used in a send e-mail script.

In the other Hand, when I export to pdf that call field from the eMail Table on the ipad everything work.

Since it works with a new file but not the existing file, there is probably something internal to the file that FileMaker Go does not like. Run a Recover on the file, and try again. If the recovered file fails, then I'll want to see the file. Remove all of the imported MySQL data since it is not part of the MainTable or eMail Table, and then send me the stripped down file so I can determine why the Send Mail is not using the related data. Check your Inbox at the top of this page for instructions where to send the file.

I solved the problem. I found that weird but i manage to get the proper result.

The Field in the Main Table on what the relationship is based was a Global Field with an Auto Enter made by the script. I Changed to a regular calculation Field (mean not Global) and everything worked as it should.

I still don't understand why that worked on the mac but not on the iPad.

I don't know why it works on a Mac but not on the iPad. So that I don't reinvent the wheel, can you provide me a clone of the file (without the MySQL tables). I'd like to do some testing here so I can make sure the inconsistency with global field relationships gets reported properly. Use the information from the private message I sent earlier.