Thank u guys for ur help,, i will surely follow andy's suggestions and let u know

no the same city will have different ids if it is present in different states...

quote:

---

What do you mean by "not displayed"? That is different from not having enough room in the column to hold the data...