Hi!

I have a flat file for US cities and I see it contains such field as a 'county'. Is it not the same as a region? Do you need custom regions or just a user-defined regions?

>Hi everyone,
>
>I have a problem, which I'm not sure, how would be better to solve in terms of Interface design and Data organization.
>
>We have Towns table which contains towns in 4 states (MA, CT, RI, NH). This is a big flat file. Town (C 4) is a unique identifier.
>
>I want to produce Custom Mortgage Market Share Report. The word Custom here means, what customer would set parameters for this report. For instance, what price/mortgage range he wants, should it be based on $ Volume or by Numbers, etc.
>
>One of the problem, related with this report, is that customer should be able to specify and name regions.
>For instance, Customer1 defines 5 Regions:
>Region1: Town1,Town2, etc.
>Region2: Town6,Town7, etc.
>etc.
>
>For this particular problem I'd like to hear your opinions. How should I organize data/form for this?
>
>Your ideas would be greatly appreciated.
>
>Thanks in advance.