is there any way to write a calculation that would list all the values of a certain field, within the found set.

this would be used in a 'set field' script step

i really really need this fast, if someone could try to help. also the script will be a loop that repeats 12,000 times, so keep that in mind; i'd like it to run quickly.

also, i don't know why, but i made one attempt to do this by exporting field contents to a .tab file and then setting that file as the url in a webviewer and then using getlayoutobject attribute, but it didn't work because the webviewer wouldn't open the .tab file. i don't get why. did somehing change between versions 8.5 and 10 (i'm using 10 adv.) that made it impossible to open local files with web viewer?

i also tried to insert the file into a container but that didn't seem to lead anywhere.

a calculation that would just aggregate the field by itself, would be ideal

i figured usuing relationships would have messed up the script too badly, so using a value list seemed out.

idk. please help.

i'm using pro 10 advanced and windows xp

also, i know i probably could have done this using a self-join; but i thought that might be bad, since this database is already larger than a gigabyte (too many records; too much indexing; and 1 self join already - i'm not sure, but wouldn't more self joins make it worse?).

it's actually really annoying that you can export the aggregated contents of a field into a .tab file, from a sorted found set,

but you can't just export that into a text field.

what's up with that?

a calculation that would list all the values of a certain field, within the found set.

You would need a custom function to do this by calculation. However, it is not clear why you would need such thing, if this is going to be used in a script anyway.

You could, for example, create a new layout containing only the field you are interested in, go to that layout, copy all records, go to another layout and paste into the target field.

There are other ways, but it's hard to advise with so little to go on.

BTW, a self-join would ignore the found set, and so would a value list (in addition to removing duplicate values).

thanks comment. that 'copy all records' thing seems to be working. I don't know why I couldn't use webviewer, but this was probably better, and maybe faster for the script.