Autofill field with entry into another field


J

Judy Rose

I am working on setting up a new database that has one main table and a sub
table linked to show a list of all workers, the table with the workers needs
to have their supervisors listed for each worker, I have two columns one to
show the supervisor ID and one for the supervisor name, is there any way I
can program the system to show the supervisor name in it's column once I
enter their ID in the respective column?

I am going to have a ton more questions with this set up as I am trying to
create a master database for the entire office of what I have already set up
for myself in Excel and I know there are ton's of ways to better manipulate
the data, but am not very savvy with programming as of yet.

Thank you in advance for any help.
 
Ad

Advertisements

J

John W. Vinson

I am working on setting up a new database that has one main table and a sub
table linked to show a list of all workers, the table with the workers needs
to have their supervisors listed for each worker, I have two columns one to
show the supervisor ID and one for the supervisor name, is there any way I
can program the system to show the supervisor name in it's column once I
enter their ID in the respective column?

If you're trying to include both the supervisor ID AND the supervisor name in
the worker table... DON'T. It's redundant and unnecessary.

In addition, you really should not be looking at (or letting users look at)
table datasheets AT ALL. If the table of supervisors has an autonumber ID, it
won't be meaningful to the users anyway; you'll be much better off using a
Form with a combo box, storing (but concealing) the ID and displaying the
supervisor's full name.
I am going to have a ton more questions with this set up as I am trying to
create a master database for the entire office of what I have already set up
for myself in Excel and I know there are ton's of ways to better manipulate
the data, but am not very savvy with programming as of yet.

We're nowhere near doing any programming yet... but you do need to learn how
to normalize relational tables. They may look like spreadsheets *but they are
different* and require different logic!

For some tutorials and suggestions see

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top