Using Set Field script step

[kaosgds]

good day!

i'm still having trouble with this one pickle...when i run the find categories script, i want the directory layout to print the found set with the category field chosen by the user in the header, which i've attempted to set to DCategory.

it's unclear what i'm doing wrong, but i either don't get a value at all or simply a zero in the merge field when i run the script. i tried to use the Category field as the merge field instead, but that only works when the matching category was chosen first in data entry. (some listings belong to multiple categories)

i'm attaching the file to look at, any ideas where i'm making my mistake?

thanks

db

GLCCtestdatabase.zip

[sbg2]

Try the attached

GLCCmemberdatabaseCopy.zip

[kaosgds]

that seems to work, but i'm trying to figure out why.

it seems you used a global field, how does that make a difference in setting the field? also, you also fixed the problem i had that the records i knew were there didn't always come up. how did that work?

thanks so much for your help!

have a beautiful day

db

[sbg2]

Sorry I didnt see this earlier in the week. Did you figure out what I did? To be honest I can't remember at this point, but if you still can't figure it out I will go back and look at both solutions and try to provide an explanation.

[kaosgds]

i'm still not quite sure what you did, but i've gotten some other help with it since anyway so what you wrote may not even be the same in my file anymore.

the global field thing is still not making sense to me, because if it's supposed to have the same value for all records but it keeps changing, then it's not the same. that's probably a question for a different forum.

thanks for the followup

db