I need to place each of the values in a list into separate fields so I can do further calculations on them separately.

Is there a way of getting each value in a list into separate fields within the same record?

Thanks for you help (again)

John

"I need to place each of the values in a list into separate fields so I can do further calculations on them separately."

Why? FMP 8.5 and later has several functions that allow easy selection of values from a list. This can be combined with variables and recursive custom functions to do practically anything in a single calculation field.

You'll need FMP Advanced to create or edit custom functions.

separate fields within the same record

...Or why not keep separate values as records in a related table, shown via a portal perhaps even cut up.

Well here's a suggestion that might fit you problem?? But as such a stab in the dark!

--sd

test.zip