>Thanks for your help. I used your routine to add the two columns but only have the one visible. set the columncount in the properties window.
>
>do while !eof()
> this.list1.additem(otemp.coll_desc)
> this.list1.AddlistItem(Transform(otemp.coll_seq), this.list1.NewItemID, 2)
> skip + 1
>enddo
>
>and then for the Update I update the base table (collat) directly and then i have a routine that copies the collat records to otemp.
>
>if SEEK(m.obligor+m.obligation+m.unit,"COLLAT","OBR_OBN_UN")
> SELECT COLLAT
> SCAN WHILE obligor+obligation+unit = m.obligor+m.obligation+m.unit
> for x = 1 to thisform.list1.listcount step 1
> if collat.coll_seq = int(val(thisform.list1.list(x,2)))
> replace collat.coll_seq with x
> exit
> endfor
> ENDSCAN
>endif
>
>Not very fancy but I think it works. I have no flexibility for adding any indexes. This application is distributed to about 30 sites.
>
>Thanks for the help. With your help I actually got an entire screen done in one day! That is good for me. I am not very good with FoxPro and I get all tangled up in the syntax.
>
>Have a nice Thanksgiving.
>
>Brenda

Glad I could help!
Eat lots of turkey <g>