Creator queries

Creator queries

Hi,

I have a couple of doubts.

1) How do I display a calculated field in the formview?I have calculated the field in the script but I want to display that field in the view.

2) now for a bug or I am doing it worng:
"update records" within a "for each row" loop updates all the records with the value of the last row.
whereas I expect it to update the value for that row.
for example: I am doing a rate * comm for each row but it updates all the rows with the value of the last row's rate * comm value.

Can you please clarify and if possible before today as I get time only on sundays for this?

Thanks,
Curious_lad