Access 2003 Relationship Difficulties (anyone else?)

[BuckBaxter]

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?

[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!

:)