Hi Vlad,

In pur towns table we have field county (fullname) and ccode (county code). We also have registry, region, etc. Anyway, this is not enough, because our customers want to define their own regions. E.g. North MA, South MA, West Ma, East MA (just an example, not real regions). They select towns, which by theier opinion belong to the new defined region. They also have to set some Sort Order (how do they want this defined region appear in a report). They may assignorder to each town within region too (probably, I have to check the spec about it).

Anyway, the idea is that customer would select towns from the list and define (describe) region.

I have a vision of Mover ListBox and some action button, lke Define new region.
But I'm not sure. I also not confident, do I need to create a file per customer or one big file to store all cusomers with their defined regions. My query from our main database should join this table and therefore idea of file per customer seems more easy to implement, but again, I'm not sure.

This is a problem: make this algorithm as much generic, as possible to use one program for generating any kind of Custom Mortgage Report. The report itself, perhaps, should also be generated on the fly using predefined template.

I'd like to exchange ideas and create a document first, before actual implementation.


>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.