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 seperate
table where PROJ corospondes to Projector. I want to know what I need to do
to link these tables so when PROJ was quered for it would pring Projector on
my site. I would be greatful if someone could help me solve this issue
which Im sure is pretty simple. Thanks for your input
Jo Jo Sam
 
Hi Jo Jo!

I´m not 100% sure that I understand your Q properly so forgive me if my
answer isn´t what you´r after!

When you say "linking tables" I asume you mean that you need to set up the
relationship between some tables!?

This can be done in 2 places.

1.) If you want a permanent relathionship you should do it using the button
"Relationship" on the standard tool menue!

A) Open the window <Relationship> up using cmdButton "Relationship".
B) Right_click somewhere in the window. Select what option which suits
you best. If you select all tables they will all show up in relationship
window.
C) The bold field in each tables are the primary key which is most
common to use when "linking" tables. I would say that´s it should almost be
the only one! Use left mouse button and use "drag & drop" to create a
relationship between your tables. Which option to use please read in the
helpfile!
D) Save the relationship.

2.) If you whant to create a relationship that isn´t going to pe permanent
you could do it in the querydesign window. Well permanent is not the correct
word, because it´s permanent for this query but if you create another query
you have to create the relationship once again.

A) Open up query design window.
B) Select the tables you need!
C) Use same technique as in my example no. 1 (drag & drop).
D) Save the query.

Like I said I´m not sure this is what you where after because ther is
something else, than what i have tryed to explaine abowe, which is called
"liked tables" which is something differnt and is used between 2 databases
or between the current db and some other data source (doesn´t have to be an
Access db).

// Niklas
 
Back
Top