related field

hi i’ve created a new table called classtecnic with 2 field idtecnic(extendeddatatype) and number.
in the M_ASDstatisticaldataform i’ve created a new tab where you can see the two field.

I want to:

when i change the idtecnic the value of number change with the value of classtecnic number.

for example:

code ABC number 6(classtecnic)

code BBC number 3(classtecnic)

select ABC number 6 then i change the code to BBC and number value = 3 (M_ASDstatisticaldataform)

it’s possible?!
Someone can help me please?
thank you very much