relatioship diagram

[winshent]

I am documenting my database and just realised that my relationship diagram is showing one of the relationships oncorrectly.

The foreign key field is set as indexed with no duplicates, but the relationship diagram displays it as a one-many relationship..

am i missing something here?

 

[winshent]

sorted !!

it appears that the relationship diagrams do not update. I must have set the index no duplicates on the foreign key after i created the relationship..

 

[winshent]

Hi Pat

Thanks for your comments.

Not sure why you suggest putting CompanyID in the phase table, as its a one-one relationship.. so in my mind it wouldnt make any difference ???

I hear your second point.. I never use autonumbers when i am designing a database from scratch as i find them quite limited.. i much prefer to 'roll my own'..