We use an FMP order processing system for call-in orders, and after the order is taken, a "send mail" script runs to let accounting know to expect payment. However, in cases where the order contains more than one item (related records is a LinteItem table), the text calc in the "send mail" script step is only capable of sending the first item on the order. Is there a way to include all related records in a "send mail" text calc?

Edited August 1, 200619 yr by Guest

FileMaker 8 would make this slightly easier, but with 7 I would probably go to the related line items and loop through them, setting them into a global field. Then use the global in the send mail step.

Thanks, Fitch. Your kind suggestion and the swift positive results I got shows how badly I need to study repeating fields and really soak up all the uses of globals...!