Copy and paste values.

[etsmarines]

I have one big table for contact management. Three fields are spouse_fname, spouse_mname, and spouse_lname. I also have husband_fname, husband_mname, husband_lname and wife_fname, wife_mname, wife_lname. I want to populate the spouse fields using a script instead of copying them over one by one from husband or wife since there are about 6000 contacts I am dealing with. I set a up a script so that.

Go to record(first)

Loop

If(isempty(spouse_fname)and (not isempty(husband_fname)

copy(husband_fname)

paste(spouse_fname)

copy(husband_mname)

paste(spouse_mname)

copy(husband_lname)

paste(spouse_lname)

else if(isempty(spouse_fname)and(not isempty(wife_fname)

copy(wife_fname)

pasete(spouse_fname)

copy(wife_mname)

paste(spouse_mname)

copy(wife_lname)

paste(spouse_lname)

(end if)

go to record (next) (exit after last)

(end loop)

the script seems logical the problem is that the values are not being copied from one field into the other.

What could be causing the values to not be copied and pasted. I know there are values there too i checked.

THanks!

Edited May 26, 2010 by Guest

[bruceR]

Use set field rather than copy/paste. Set field works whether fields are on the layout or not. Copy/paste messes with users clipboard and is generally considered poor practice, and fails if fields are not on the layout. Example

Set field[ spouse_fname ; husband_fname ]