I have 10 different record with note (text) and what I want is put all note in one field.

Is anybody can help me ? I'll appriciate your kind help.

Ben

Do you mean you want a global field?

Do you mean something like

Set Field [globalText, ""]

Go to Record/Request/Page [First]

Loop

Set Field [globalText, globalText & Note & "¶"]

Go to Record/Request/Page [Exit after last, Next]

End Loop

?

Hi que

Yes I do need a global field, I'm not doing your sugestion yet... but I have other question is that work for record that have same name ?

for example in 10 record that I have there is record that have same in field "NAME" so I want to put field "NOTE" in the global field but only record that have same field "NAME"..

thank you for your sugestion and help

If I understand correctly, you want to create a unique list of Notes for all records matching the current record's Name value. If this is the case, then create a self-relationship based on Name and a value list based on 'only related values' from selfrelationship::Notes. An unstored calculation of ValueListItems( Status(CurrentFileName), "yourValueListName" ) should then give you the desired result.

Hi que..... I still working on it.. but I thing I should have brian surgery.... I had make selfrelationship also value list but I still don't have clue for valuelistitems specially on "yourvaluelistname" can you give me more clue......

Thank for your kind..

Ben

"yourValueListName" should be replaced with the name of your value list. Sorry if that was not clear.

Thank's a lot que...

I working on it and will let you know the result after weekend..

Have nice weekend and thank for your kind help..

Ben

:beer:

Que.. you'r the Man..

Work like I want.... thank alot ( in my language - Terima kasih Banyak )