I suggest you update your design to not use repeating fields in this fashion. A table of related records displayed in a portal is much easier to work with. You can open the Invoices starting point solution from filemaker 11 to get an example of this can be done.
That said, your calculation field will work if you set it up correctly.
Define Version as a calculation field: Rightwords ( productfield ; 1 ). In the lower left corner of the specify calculation window change repetitions from 1 to 15 to match the number of repetitions in the repeating field. Change the return type to text.
That should work for you.
Thanks, I'll give it a shot. In the new database we have totally removed the repeating fields, all I am worried about is getting these bits of info out of the ones in the old database.
One useful option for extracting data from repeating fields is that you can specify that values in repeating fields be imported into separate records when you import data from an older version into a new version without the repeating fields.