Relationships/ or Linking ??

OK..

Let's say I have a table with 2 columns One field has a name in it, and the
2nd field has a phone number .

Now I create a "new" form with 2 fieldboxes, named " Name" & " Ph. Number".
The first box I want to have a dropdown with a list of names, which will be
the names from field 1 of my above table I already created. And when I click
on the name in that dropdown field, how do I get the corresponding phone
number to show up automatically in the field below named " Ph. Number" ??

I hope you migth understand what I'm asking. Basically, how do you gets a
whole record to show up in a main database when you click on just one thing,
like in my example..

Is it a relationship between tables or is it some kinda link ??

Help

Thanks

MPC wrote:
OK..

Let's say I have a table with 2 columns One field has a name in it,
and the 2nd field has a phone number .

I hope you migth understand what I'm asking. Basically, how do you
gets a whole record to show up in a main database when you click on
just one thing, like in my example..

Open Help, and search for AutoLookup Query. You'll see the help topic
"About AutoLookup queries that automatically fill in data"

--
Joan Wild
Microsoft Access MVP

Thank you Joan.. I will give it a shot !!!




"Joan Wild" wrote:

MPC wrote:
OK..

Let's say I have a table with 2 columns One field has a name in it,
and the 2nd field has a phone number .

I hope you migth understand what I'm asking. Basically, how do you
gets a whole record to show up in a main database when you click on
just one thing, like in my example..

Open Help, and search for AutoLookup Query. You'll see the help topic
"About AutoLookup queries that automatically fill in data"

--
Joan Wild
Microsoft Access MVP

if you make your "name" box a combo and in its on update event type
Me![Phone] = [name] column(1)

"MPC" wrote:

OK..

Let's say I have a table with 2 columns One field has a name in it, and the
2nd field has a phone number .

Now I create a "new" form with 2 fieldboxes, named " Name" & " Ph. Number".
The first box I want to have a dropdown with a list of names, which will be
the names from field 1 of my above table I already created. And when I click
on the name in that dropdown field, how do I get the corresponding phone
number to show up automatically in the field below named " Ph. Number" ??

I hope you migth understand what I'm asking. Basically, how do you gets a
whole record to show up in a main database when you click on just one thing,
like in my example..

Is it a relationship between tables or is it some kinda link ??

Help

Thanks