How to connect same columns in two different tables

Hi Team,
I have created two tables in access named enquiry table and Follow-up status.
There is one column called enquiry_form_no same in both tables.
After then i created forms also called enquiry form and follow-up form.now the query is that i will enter the enquiry form number in enquiry form manually but i want that while entering data in follow-up status form the enquiry form no should autmatically fill.
pls guide how can i do that?


Regards
Aparna

Create a subForm, on the other table.
Then bind the subForm on the matching key field.
Then you can enter data into the subForm and the keys will fill in.