Lookup

A

Amanda

I have an access database that I'm creating. I have a table that lists my
company's dept #s along with the Dept Name. I'm creating an ongoing 2nd table
that will keep track of dept. transactions. What I'm looking to do is when I
type my Dept's # into a field the name will auto populate. I know you can do
this in Excel by using VLOOKUP - How can I do it in Access? Please help
 
J

John Vinson

I have an access database that I'm creating. I have a table that lists my
company's dept #s along with the Dept Name. I'm creating an ongoing 2nd table
that will keep track of dept. transactions. What I'm looking to do is when I
type my Dept's # into a field the name will auto populate. I know you can do
this in Excel by using VLOOKUP - How can I do it in Access? Please help
Click to expand...

Don't do it.

Access is NOT a spreadsheet. It's a relational database. As such it
obeys what I call the "Grandmother's Pantry Principle" - "a place -
ONE place! - for everything, everything in its place". The department
name should be stored in the Department table and *ONLY* in the
Department table; storing it redundantly in the transaction table is
not only unnecessary, it's *bad design*.

Just use a Query joining the two tables if you need to see the
department name in conjunction with transaction data; and/or use a
Combo Box to store the department number while displaying the name.

John W. Vinson[MVP]
 
Top