Hi everyone,

I want to design form with threee tables:
Parent - Child - GrandChild and I'm not sure, how to proceed.

The parent table describes report configuration. It should be one per customer (I was thinking about making CustomerID to be primary index, but user should be able to delete record and re-add, so may be CustomerID would be regular index (assuring, that there is only one record per customer and ConfigID would be primary index).

Child table is related with config file by ConfigID and it contains Region definitions, e.g.
ConfigID1 RegionID1 RegionName1
ConfigID1 RegionID2 RegionName2
ConfigID1 RegionID3 RegionName3
ConfigID2 RegionID4 RegionName4
ConfigID2 RegionID5 RegionName5
etc.

and the child table of this one is towns per regions, e.g.
RegionID1 Town1 FullName1
RegionID1 Town2 FullName2
RegionID1 Town3 FullName3 etc.

When user invokes this form, oJC.CustomerID property is set, so user should be able to see records related to this customer ID (it they are exist) or the new empty record should be added.

I'm not sure, how should I design this form. User should be able to fill all configuration info, then add or change regions, then add towns (say, using Mover listbox) for each particular region.

Do you have some ideas for me to start?

Thanks in advance.