Relationships/ or Linking ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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..
Click to expand...

Open Help, and search for AutoLookup Query. You'll see the help topic
"About AutoLookup queries that automatically fill in data"
 
Thank you Joan.. I will give it a shot !!!




Joan Wild said:
Open Help, and search for AutoLookup Query. You'll see the help topic
"About AutoLookup queries that automatically fill in data"
Click to expand...
 
if you make your "name" box a combo and in its on update event type
Me![Phone] = [name] column(1)
 
Back
Top