How to Design this form ? please help...

[saleemMSMS]

i have 2 tables here are the information about the 2 tables

organization (OrgID, OrgName, OrgTypeID, PresidentsName, ContactNumber)
OrgType (OrgTypeID, Description)

i designed 2 forms seperately for the 2 tables. using form wizard.
but in the Organization Form, the user is required to enter the OrgTypeID.
this can lead to data entry errors since a Data Entry Operator cannot memorize all the Org types at the entry time.
so i thought of having a combo box where all the names are available. so the DEO should select the appropriate name and then the numbe will appear automatically..

is this possible to do in bounded forms ?
please explain me how to do this.
i'f i'm missing something.. also please say...

 

[Galaxiom]

RowSourceType: Table/Query
RowSource: SELECT OrgTypeID, Description FROM OrgType ORDER BY OrgType.Description
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0;whatever