New user needs getting info from tables explained..

[Guest]

Hello, I’m new to access and wanted to know if someone could explain how to
get the data from a table if the data is stored as a number or ID from
another table. Do I run a query and link them together? Example: Let’s say I
have a Main table that stores an employee’s name. The table that has the
employees name has a primary key that’s the number its storing in my Main
table. Now if I have a form "Not a report" that I want to show the record
from the Main table with a text box then how do I show the employees name and
not the ID number? I’m I making sense Thanks!

 

[John W. Vinson]

Hello, I’m new to access and wanted to know if someone could explain how to
get the data from a table if the data is stored as a number or ID from
another table. Do I run a query and link them together?
Yes.

Example: Let’s say I
have a Main table that stores an employee’s name. The table that has the
employees name has a primary key that’s the number its storing in my Main
table. Now if I have a form "Not a report" that I want to show the record
from the Main table with a text box then how do I show the employees name and
not the ID number? I’m I making sense Thanks!

Two ways: 1. Base the Form on a query joining the two tables.
2. Better for most uses, and certainly more common - put a Combo Box on the
form, bound to the EmployeeID field but having the employee's name as its
first visible field. The Combo Box wizard in the toolbox will set this up for
you.


John W. Vinson [MVP]