I need help with linking tables

  • Thread starter Thread starter Jo Jo Sam
  • Start date Start date
J

Jo Jo Sam

Ok here is the situation. I have just started learning and using access in
conjunction Coldfusion. I am learning about tables and things and have made
a pretty good data driven site using simple SQL queries. I have a database
with product abbreviations, price and other things in each record. I want
these product abbreviations which are like PROJ to be linked to a separate
table where PROJ corresponds to Projector. I want to know what I need to do
to link these tables so when PROJ was queried for it would print Projector
on my site. I would be grateful if someone could help me solve this issue
which I'm sure is pretty simple. Thanks for your input
Jo Jo Sam
 
You are talking about creating relationships. In the
database, select Tools -> Relationships. Add the two
tables, and drag one field on to the second.

But, this doesn't necesarrily do what you are talking
about. Access won't create the automatic changing that
you are talking about. You will either have to do it from
the ColdFusion <query> tag, or create a seperate Access
query to pull the data from.

I would highly suggest opening the Northwind database and
see how they set up their relationships.



Chris
 
Back
Top