Two problems with Visio 2000 - MS SQL Server

L

Leonardo

Hi.
I have Visio 2000 running reverse engineering from a MS
SQL Server Database.
I have two problems.

1) I want crows feet, and althought I have Nulls allowed
in the FK from SQL Server, Visio sets cardinality to "one
to cero or more" instead of "cero or one to cero or more".
I have to manually set each relation "optional" to fix
this.

2) I dont want the FK to be part of the PK in most cases.
That is a "Non-identifying" relation. Visio represents it
with a non continuous line (dashes). I want a solid line,
but the model doesn't allow me to format it manually.
The only way to get a solid line is to "cheat" Visio ;-),
setting the relation as "Identifying", and then unchecking
the PK checkbox for that field in the entity. The line
remains continuous althought the relation is "Non-
identifying" again.
The problem is that when I do this, I lose the "optional"
check to fix the previous issue.

Does anyone know how to work this around?

Thank you
Leonardo from Argentina
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top