about the relationship in the visio

I'm a beginner in the MS. Visio, I would like to do the ERD in Visio, when I do the relation ship I type the foriegn key before in the tables, but the software add to the table the all the primery keys for the related table as foriegn keys, which is out of my requirments... what to do to control the relationship at all...
Ahmed82Asked:
Who is Participating?
 
gvsbnarayanaCommented:
Hi,
  Please check the relationship type.. I don't recall exactly but it depends on relationship type.
The types of relationships are "Identifying" and "Not-Identifying"
If you select a relationship type "Identifying", then it will add the FK to PK list.
You can right click the relation link, make it "Not-Identifying" and uncheck the PK box.
PS : I don't have Visio now but it was my experience with Visio 2003.
HTH
Regards,
Badri.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.