How to get values from other tables

H

Hugo C.

I want to change my database in excell for a faster one in acess, and i don´t
know how to get values from other tables or queries. Exemple:

Querie 1
product*sytem

Table 1
product*system (whit a diferent name, but whit the same information)
type of product

I want to know to insert in querie 1 a new colun whit type of product,
similar to the vlookup function in excell
 
S

scubadiver

Use a make-table query.

Having said that how much do you know about Access? If you are a novice
don't get too far ahead or you may regret it.
 
S

Steve

You want to have the following table:
TblProduct
ProductID
<Product Information Fields>

Then in ALL other tables where you need to refer to a product, you want to
reference products by ProductID.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
J

John Marshall, MVP

So it is business as usual, no apolgies for being wrong or your boorish
behaviour. It is on to your next victim.

John... Visio MVP
 
J

John W. Vinson

I want to change my database in excell for a faster one in acess, and i don´t
know how to get values from other tables or queries. Exemple:

Querie 1
product*sytem

Table 1
product*system (whit a diferent name, but whit the same information)
type of product

I want to know to insert in querie 1 a new colun whit type of product,
similar to the vlookup function in excell
Click to expand...

Excel is a spreadsheet.
Access is a relational database.
THEY ARE DIFFERENT! Access is not "Excel on steroids"; it's not a faster
version of Excel; *it is not a spreadsheet*. It requires different logic and
different procedures; expertise in Excel can be an actual hinderance in
learning Access, since you have to "unlearn" some of the "this is the way
things are always done" (such as VLookUp).

Check out some of the information here, especially Jeff's Database Design 101
links and Crystal's tutorial:

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

John W. Vinson [MVP]
 
Top