>Thanks
>>I have to tables one Client, the other policy. I didn't have a group code<
>> field in the table, because it was inported via a text file. I have the group<
>> code present in the client table. Because the policy database has a ssnumber<
>> Tag field, and the Client table also has a ssnumber tag it forms the relation<
>> Because there may be more then one policy assigned to a ssnumber in the< >policy table , I need to pass the group code with each each ssnumber in the< >policy database from the client.<
>
>>I need to place a group code in all of the policy records from the client<
>> table <

---

Let's try another one :)

select policy
set order to tag ssnumber
select distinct ssnumber from policy ;
  where empty(group_code) ;
  into array aMissing

if type("aMissing[1,1]") = "N" && Assuming they're numeric
                               && _tally > 0 could be too
 for ix = 1 to alen(aMissing,1)
    if seek(aMissing[ix,1],"client","ssnumber")
       lnGroupCode = client.group_code
       =seek(aMissing[ix,1],"policy","ssnumber")
       replace group_code with lnGroupCode ;
              while ssnumber = aMissing[ix,1]
    endif
 endfor
endif

Cetin