469,331 Members | 1,817 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

Access 2003 Relationship Difficulties (anyone else?)

Recently had trouble creating a one-to-many relationship between Customer table and Order table. After drag & dropping the field CustomerNo (key) in Customer table to CustomerNo (foreign) in Order table, the relationship wizard would begin making a one-to-one relationship. After a lot of searching, I still don't know why the wizard thinks I want a one-to-one relationship or how to change that. However, when I deleted the field CustomerNo from the Customer table - then re-created it - (same table, data type, etc.), the relationship wizard then allowed creation of the one-to-many relationship I want. Is there a better way to coerce the wizard to specify what type of relationship you want? Or, a backdoor method of creating relationships?
Oct 6 '06 #1
1 1752
PEB
1,418 Expert 1GB
Hi man,

Instaed to delete your field you need simply to change one property
The property Indexed have to be set Yes dublicates in your table with many values...

If in the one table the key is auto number in the many table you need to assign it as longint!

It's all!

:)
Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Danny J. Lesandrini | last post: by
4 posts views Thread by alexandre.brisebois | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Purva khokhar | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.