In a table are 2 depending fields "area" und "subarea" with an 1:n relationship.
Of course there is a maintance-table with excact this kind of information
I want to zoom on this table to select area and subarea, but since i have two fields, I get two separate zooms and this leads to wrong inputs with subareas belonging to other areas.

Sorry, if I confuse you :confused:
Example:
area subarea
A 1
A 2
B 3
B 4

First the form zooms to area and the user selects area A. Next the zoom on subarea is called and the user selects 3 but should see only the possible subareas 1 or 2.

Can anybody give me a hint how to handle this ?

TIA

Regards

Hi ,

there are 2 ways of doing it...

1. Disable SuabArea Field For Input and when u zoom from Area Field , return its correponding SubArea Value as well and forcefully assigned it in SubArea Field on the Form..

E.g
area subarea
A 1
A 2
B 3
B 4

If u select 2nd Row in Above Exapmle,then Area Field would be populated with "A" and its SubArea with its associated value i.e "2".

2.Another way is after u have zoomed from Area Field, capture that (Area )value and export it to Zoom Session from SubArea Field.

E.g

area subarea
A 1
A 2
B 3
B 4

Suppose that u have chosen 2nd Row while zooming from Area Field, assign this "A" value in before.zoom section of SubArea Field. After this is done , then if you try to zoom from SubArea Field , it will only display records corresponding to "A".

Cheers,
Abattoir