Need Help with Calculation
I think I need some specific coding help. I created a button to send an email to specific addresses depending on the selection in a field’s drop down list and I am having trouble getting it to function correctly. (We have not received FileMaker Pro Advanced yet) The script has an error right after the “Commit Records/Requests” and it says “The operation could not be completed because the target is not part of a related table.” Not sure what this means or what the target is. The script is pictured below.
In the Send Mail script step, I have a calculation to ask to email specific people depending on the selection in a field. It looks something like this:
If(Observations::Jobsite = "90165 - Oneok MB1";
If(Observations::Jobsite = "90155 - Oneok MB2";
Now, I understand I could nest the If functions, but there's at least 30 of them.
How do I find out what the "target" is to make sure it's part of a related table?