Cell referencing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to use a function (similar in nature to the VLOOKUP in Excel), to use the value entered in one cell, to update a value in another cell automatically, using a separate table as the reference?
 
Is it possible to use a function (similar in nature to the VLOOKUP in Excel), to use the value entered in one cell, to update a value in another cell automatically, using a separate table as the reference?
Click to expand...

STOP.

Excel is a spreadsheet, a good one.

Access is a relational database.

THEY ARE DIFFERENT! You can drive nails with a crescent wrench, but
that doesn't make it a hammer! Study up about how relational databases
work.

Access tables don't have "cells". They have Records, which consiste of
Fields.

What you want (I'm guessing) is a Query joining the two tables, by
their primary key/foreign key field links. If you want to see the
value from TableB in association with the value from TableA, create a
Query joining TableA to TableB and view the data in the Query.
 
Back
Top