relationships

A

angelina

Hi,

Just a quick question.

I have obtained a software obtained off the net for a
evaluation period. They have given me the Access Database
and i just wanted to know how i can see how they have
connected the tables together. (i.e their relationships.
1:m, M;N etc). as u can tell im a beginner to access!!
All i can currently see is a list of all the tables.

many thanx
x
 
A

angelina

Hi Dave,

i have tried this but all i get is a 'show table' dialog
box asking me which table i would like to add. it doesnt
show me the relationships that the developer has already
estalished in their DB. is there any way i can get around
this?
thx
 
D

Dave Jones

Hi,

How many files were in the download? With Access, it is
usual to split the database into two, the front end
containing forms queries etc and the back end containing
the data and relationships.Make sure you are opening the
back end if this is the case.

Alternatively, where did you get the software from?

Dave
 
D

Dave Jones

Hi,

Downloaded and had a quick look at it. Don't know what it
is supposed to do, but it is clear that there are no
relationships between the tables. Maybe you are supposed
to create them yourself!

If you want to have a look at relationships between
tables, search on your PC for Northwind.mdb (comes with
Access), and have a good look at that.

Dave
 
A

angelina

Hi Dave

Thx for your help. Its much appreciated. I just wanted to
know how those developers went about created the db for
that video rental software as i will be creating a
similar appliactiion soon and just wanted to get a rough
idea of how to go about it. I will try and locate some
more appliactions along these lines to see what else i
can find.

Thx again for your time. :eek:)
 
D

Dave Jones

I must admit, I don't envy you. For someone new to Access
the project you are looking at is fairly ambitious.

Having said that, if you look at the tables in the
database you downloaded that will give you a starting
point.

Also, get yourself a good book on Access (have a look at
some of the other posts in this group for recommendations).

Lastly, when you have a problem, post it to the
appropriate group here. Someone nearly always has the
answer!

Good luck

Dave
 
S

Steve Schapel

Angelina,

Although it is very unusual to have a database where no relationships
at all are defined, it is perhaps worth remembering that Relationships
defined in the relationship window don't actually *do* anything. The
only real reason to set them up there is if you want to enforce
referential integrity between tables, which is not always the case.

- Steve Schapel, Microsoft Access MVP
 
A

angelina

thx for all your help and advise guys. theres no doubt
i'll be bugging u guys again
:eek:)


-----Original Message-----
Angelina,

Although it is very unusual to have a database where no relationships
at all are defined, it is perhaps worth remembering that Relationships
defined in the relationship window don't actually *do* anything. The
only real reason to set them up there is if you want to enforce
referential integrity between tables, which is not always the case.

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top