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

Access 2003 Relationship Difficulties (anyone else?)

P: 6
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
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
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.