Automatic data in a table

sabrecoach

New Member
Joined
Mar 6, 2003
Messages
17
Hi everyone,

I have a small problem related to Access. I'm building a DB for the employees of my company.

The problem that I'm encountering is that i'm writing down an employee number and I want the table to automatically write down the first and last nam of that employee. The employees informations are in another table.

How can I do that

Thanks

Patrice
MTL, Canada
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,102
Office Version
  1. 365
Platform
  1. Windows
Patrice

Where are you doing this? In a form or table?

What do you actually mean by 'writing down'?

You should probably be able to use a combobox/lookup based on the employee table.

It would display the employee name but the underlying field would actually be the employee number.
 

rictorg

New Member
Joined
Jul 8, 2005
Messages
12
I saw this topic on the front page, and just had to hijack it!

I am utilizing an access db where we use an employee identifying number, and it looks up the employee's name and supervisor. However, the form doesn't actually capture that data, so when I export the results, those fields are blank. I would like to be able to use a query, or have the form itself include that data. Currently, I have been exporting to Excel, and doing a quick vlookup to associate the two, but as I am delegating part of the project, I want to make it as easy as possible for them.

What would be the best way to do this?
 

rictorg

New Member
Joined
Jul 8, 2005
Messages
12
Well, aparently this board inspires me. I just figured out how to build a relationship, and that took care of it. Perhaps a board regular can articulate that better, as I kinda just stumbled on it. Off to update my Queries!
 

sabrecoach

New Member
Joined
Mar 6, 2003
Messages
17
Hi Norie,

Actually, it's in a table but I'd like to use a form. I've tried to use a form with data from three tables. The results were that I could see all existing records, but could not add any new one.

By entering, I mean typing down data in one field. In response to that typing I'd like to have the first and last name of that employee

3355 John Smith

Thanks

Patrice
 

Watch MrExcel Video

Forum statistics

Threads
1,119,268
Messages
5,577,102
Members
412,768
Latest member
klig
Top