Hi everybody,

I think, this question is pretty basic, but I hadn't experience with it so far.

I want to create three tables:
CustomerSpecific:
CustomerID ImportantLender WhatKindOfReport etc.
|
Regions table
CustomerID RegionID RegionName etc
|
RegionsSpecific
RegionID Town TownName

The user should be able to pick a customer from customer table (with probably additional functionality to add new customers), then fill some specific info about customer criteria - one record in the first table, then he/she should be able to create region groups, e.g. assign a name for each group and associate towns with each region group (ever using Mover ListBox or multiselect Grid - I haven't decided yet).

Now my question is:
How should I organize Add/Edit functionality for this design? Is it possible to do using views? Does the proposed table model seem rational?

Could you please give me some advices here?

Thanks in advance.