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
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,343
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,627
Messages
5,832,758
Members
430,165
Latest member
Idjaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top