How to get values from other tables

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

Guest

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
 
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.
 
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
(e-mail address removed)
 
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
 
Steve said:
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
Click to expand...

Get lost Steve !! we don't need you here!! , but ....
==>Let's ask it the 'nice' way...
Would you please, please go away Steve ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 3800+ pageloads, 2400+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR
 
John Marshall said:
So it is business as usual, no apolgies for being wrong or your boorish
behaviour. It is on to your next victim.
Click to expand...


I guess it is *highly unlikely* that lots of customers wil come from the groups these days...
It is all about reputation isn't it ??
If I were a customer and 'searched' for him in the newsgroup, I would be looking for someone else.

So I doubt it is business as usual... Maybe it's no business at all ??
===>> Ahhh ... *that's* why he is so busy advertising ??

I also wonder how many developers still work for him.
(Quote: "I have three full time developers working for me")
But I guess that was a lie, like usual. Never did any of these developers defend him here.
Maybe Steve is his own victim ??

Arno R
 
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]
 
Back
Top