Hello everyone,
i realise this is possibly GIS-101 for those who know, but i can't figure out how to simultaneously use layers of maps (with geological and land use information respectively) to generate a third map
with regions formed by all the possible 'splits' that can be performed between the 2 maps, while at the same time carry information that is based on conditionals from the 2 input tables to generated columns on the 3rd table / map.

I think i know how to do the first part: i set the target on one surface (say the land use layer) and i use the geology layer's regions as boundaries to split the land use regions. The areas will be split proportionally so i get the correct final areas for the split regions.

Here is the trick part though.. land use has a table of 5 columns (among other columns) named LAND_CODE, CN_A, CN_B, CN_C and CN_D.. the LAND_CODE is self-explanatory and the other columns contain 'curve' numbers used in hydrology. Additionally the geology map contains a column CN_TYPE, where the values of the column are A,B,C or D (there are CN categories).

So basically what i want now is to generate a third map or add a column on the land use map (as the 1st part that i explained above does not split the regions in a new map but 'in place')
where the condition to fill this column will be to check for every single newly created region what characteristics are 'underneath' it, i.e. the CN_TYPE from the geology layer and the LAND_CODE from land use layer and depending on these 2 values to fill in the generated column with the corresponding number from one of the columns CN_x....

Is what i say clear?
Please let me know if something is not clear.

Thank you very much in advance for your help.
I use Mapinfo 10.0