>Nadya,
>
>Sounds like you have duplicates of ccode in the towns table.
Yes, Town is a unique field in Towns table, but ccode is not. Looks like Mark's solution should work. Stupid me not think about it :)
If it's not broken, fix it until it is.
My Blog 
