Help for pulling data into other forms / tables

Hi there,

I'm very new to this online database thing, so this is quite a newbie question, so I'd be grateful for your patience and advice!

The situation is as follows:

I have two tables, Table A and Table B and two forms that directly relate to them, Form A and Form B.

Table A has three fields, Client Name, Client Address and Client Phone Number

The situation is as follows:

I want to pull information from Table A into Form B, using lookup.

So, if in Form B I have a lookup drop down called 'Select Client Name', which looks at 'Client Name' in table A and populates it as a dropdown - no problem so far.

If I then have another field in form B called 'Address', how do I populate that with information from the 'Client Address' field in Table A, based on what the user selected in the drop down in Form B?

Essentially, how do I pull data from a different table into a form, based on a dropdown criteria, using the dropdown criteria as the unique reference?

Hope this makes sense...

Thanks for your help,

Paul.