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.