one to many & many to many relationship

[ronenkf]

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#

[MGFoster]

ro*****@zahav.n et.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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQuPm04echKq OuFEgEQIUuQCdGr M8a8mtz2OxhIHfw 3mXT+sq/i0AnA0D
l0DcaQNNq5ueKkq tiUubi/kp
=Nt3Z
-----END PGP SIGNATURE-----

[ronenkf]

Solved my problem!
cheers!