need help linking table so that info pops up when certain #s used

  • Thread starter jenn needs help
  • Start date
J

jenn needs help

I have two tables, one called Employee numbers and one called Employee
charges. Is there a way-in the charges table, that once I type in an
employees number, to have there name pop up (from Employee number table)?? I
know this sounds logically, therefore I'm researching this. HELP!!!!
 
J

John Vinson

On Wed, 8 Jun 2005 13:48:03 -0700, jenn needs help <jenn needs
I have two tables, one called Employee numbers and one called Employee
charges. Is there a way-in the charges table, that once I type in an
employees number, to have there name pop up (from Employee number table)?? I
know this sounds logically, therefore I'm researching this. HELP!!!!
Click to expand...

It's much simpler if you use the tools that Access provides, rather
than trying to enter data directly in a Table.

Create a Form based on your Employees table. On it, put an unbound
Combo Box (using the combo box wizard, with the "find a record"
option) to navigate to a record. This can be done using either the
employee name *or* the employee number, or you could have two combos,
one for each.

Put a Subform on the form bound to the Charges table; this will show
only the charges for the currently selected employee.

John W. Vinson[MVP]
 
Top