By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,655 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,655 IT Pros & Developers. It's quick & easy.

one to many & many to many relationship

P: n/a
I am currently working on access 2003. Created database with 4 tables.
For each on e there is a primary key, which is a text data type. Now
I'm trying to configure relationship between tables. The problem I
cannot create the "one to many" relationships. I can only create
"one to one ". What might be the problem?
Tried to change the data type to number. One table it did solve the
problem (but then I could not put an input mask. Others left with same
problem.

Any help will be highly appreciated!

sea#

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ro*****@zahav.net.il wrote:
I am currently working on access 2003. Created database with 4 tables.
For each on e there is a primary key, which is a text data type. Now
I'm trying to configure relationship between tables. The problem I
cannot create the "one to many" relationships. I can only create
"one to one ". What might be the problem?
Tried to change the data type to number. One table it did solve the
problem (but then I could not put an input mask. Others left with same
problem.


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

One to many relationships are between unique column(s) (the one) in one
table and a non-unique column(s) (the many) in another table. A one to
one relationship is between unique column(s) in one table and unique
column(s) in another table. Check the indexes on the columns you are
trying to set relationships on.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQuPm04echKqOuFEgEQIUuQCdGrM8a8mtz2OxhIHfw3mXT+ sq/i0AnA0D
l0DcaQNNq5ueKkqtiUubi/kp
=Nt3Z
-----END PGP SIGNATURE-----
Nov 13 '05 #2

P: n/a
Solved my problem!
cheers!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.