Screen Painter

Dear Experts

I have created simple form which contains just two field

CardCode and CardName

I have created collection object type 2

Actually i want to dependent both the field each other

If I am selected cardcode from field then automatically Cardname field shuld be filled according to cardcode selection?

how it can be achieved?