Assign a value to the Category field of the Main table

Hi All,

We use SRM-MDM Catalog 3.0 SP08 patch01 (7.1.05.94).

In our main table, we have the Hierarchy field, on lookup(Hierarchy) on the Hierarchy table and the Category field, on lookup(Taxonomy) on the Category table.

In our main table, the Hierarchy field is valued.

As in tables Hierarchy and Category, we have the same hierarchy (with attributes for the second one), we would like to assign the value of the Hierarchy field to the Category field.

Does anyone know how we could make it ?

Thanks for your kind help.