relationships

  • Thread starter Thread starter angelina
  • Start date Start date
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
 
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
 
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
 
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
 
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. :o)
 
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
 
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
 
thx for all your help and advise guys. theres no doubt
i'll be bugging u guys again
:o)


-----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
Click to expand...
 
Back
Top