Hi all,

I am creating a portal and from that portal I want to populate records of another table.

I am doing this with set variable and set field.

The problem is that if I click more than once the button on the portal row, the script create duplicate records.

Ideas to avoid this duplication?

you could perform a check to see if the record exists first with a find as part of your script...

Thanks,

can you give an example? I am actually doing this with a loop function. The problem I have is that after the loop I end up on the last record, not on the current onne.

I am also trying with:

set variable [$ITEM; field]

Go to find mode

set field [field;$ITEM]

perform find

if [field<>""]

Exit script

Does not work...

A Loop? Okay before we get into a specific solution, please explain what the purpose is here...

First you state that you have a button on a portal row that creates another record in separate table ( which I dont quite follow why to begin with). Then you now state that you need a loop.