Auto Enter data based on data in another field

[Rotorian]

I have two fields with drop down lists. The lists come from a related database.

Field 1 = Card Name

Field 2 = Card Number.

In the related database there are two colums, Colum A Card Name has a corresponding Colum B with Card Number.

What i want is on the record entry database, when user chooses Card Name from the drop downlist, for corresponding Card Number to be auto entered from Colum B in the related Database.

Is it possible?

[transpower]

Relate Card Name in the record entry database to Card Name in the related database. Then make an auto entry calculation for card number in the record entry database = RelatedDatabase::card number (substitute your actual name for RelatedDatabase). Even simpler: just put the card number field from the related database directly on the layout of your record entry database.

[Rotorian]

I like it simple, tried it, it worked.

Thanks mucho .