>>Naomi,
>>
>>>I see, so you have it in both (in States and in Countries). But then, what about all the statistics? Or does it allow to pick up it as a country and then behind the scenes re-points?
>>
>>There really isn't any sort of statistical reporting where the amount of PR records makes a significant difference. If it's used to deliver mail the record was converted to country=US state=PR.
>
>And there is the key. So far I haven't seen anything here that suggests the actual purpose that Michel's tables are supposed to serve. Without knowing exactly what the two tables are supposed to be used for, it's difficult to say whether or not they need changing, or if it's just an unfortunate choice of table names.
I believe they are used for members addresses and they are also used in Members Repartition reports.
If it's not broken, fix it until it is.
My Blog