I've used the following FormCalc code successfully in a Calculation Script for placing the current DB value into a text field. The DB table is "CustomerOrders" and the column is "Address"
All of these SOM expressions are equivalent
xfa.record.CustomerOrders.Address
$record.CustomerOrders.Address
$record..Address
$record.*[0].Address
$record.*[0].*[0]
I found the information for building these expressions in the Adobe documentation. I also looked around for FormCalc Loop operators. Didn't find any. From the FormCalc Language Specification it appears that such an animal does not exits.
Thom Parker
WindJack Solutions
www.windjack.com