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.
If it's not broken, fix it until it is.
My Blog