create a form indexing many tables

[al banks]

what i want is a combobox where you select the main tables
id and then all the other fields automatically get filled
corosponding this id...

how do i create this and get new details added to save to
the table

cheers ,

al