>>Jeff
>
>Select with 'GROUP' clause will retrieve just one record for each group (the last one). You can use 'ssno' of these records as a key to update records in table. I'm not sure that View Designer will provide this for you (I would try it first), however it can be done also programmatically using
>REPLACE ssno With .... ALL FOR ssno=....
>Strictly speaking, you should use transaction here.


Thanks again!

Jeff