A
Andy_Khosravi
I'm trying to reverse engineer a database I made in Access 97. The
import process appears to be working great, it's the visual
modifications with what I've got that is causing the problems.
I'm having three primary problems; I can't seem to get figured out a
way around other than actually manually drawing the tables and manually
connecting all the relationships.
The first problem is that the relationship lines that it automatically
draws for you do not actually point to the correct fields they link
together; they only draw a line from a random location on one table to
a random location in the related table. The properties indicate the
correct foreign keys etc., but they don't actually visually connect.
I've tried drawing different line types, but other than actually
creating a connection point, and then connecting it with a custom line,
I don't see a way to automatically do this.
The second problem with the relationship lines is that they do not
reflect what type of relationship it is. (I.E. one to many, one to one
etc). All it draws is a simple arrow, which doesn't tell you much.
The third problem is just an annoyance. I'd rather not see all the
Foreign Key/Primary Key displayed to the left of the fields. Primary
keys being bold and the actual line connecting the fields are more than
adequate to show how the relationships work. Lastly, the tables show a
blank line underneath the Primary Key if the Primary Key is the only
field in that table.
In short, what I really want is something that's going to look like the
relationship tool that Access Provides, but with the ability to
manually control how the lines are draw between them as well as
something that's going to allow me to print. I haven't been able to
figure out a way to do these things, especially since the help files in
Visio constantly generate Java scripting errors and wont display. Any
help any of you can give me would be much appreciated.
Thanks!
import process appears to be working great, it's the visual
modifications with what I've got that is causing the problems.
I'm having three primary problems; I can't seem to get figured out a
way around other than actually manually drawing the tables and manually
connecting all the relationships.
The first problem is that the relationship lines that it automatically
draws for you do not actually point to the correct fields they link
together; they only draw a line from a random location on one table to
a random location in the related table. The properties indicate the
correct foreign keys etc., but they don't actually visually connect.
I've tried drawing different line types, but other than actually
creating a connection point, and then connecting it with a custom line,
I don't see a way to automatically do this.
The second problem with the relationship lines is that they do not
reflect what type of relationship it is. (I.E. one to many, one to one
etc). All it draws is a simple arrow, which doesn't tell you much.
The third problem is just an annoyance. I'd rather not see all the
Foreign Key/Primary Key displayed to the left of the fields. Primary
keys being bold and the actual line connecting the fields are more than
adequate to show how the relationships work. Lastly, the tables show a
blank line underneath the Primary Key if the Primary Key is the only
field in that table.
In short, what I really want is something that's going to look like the
relationship tool that Access Provides, but with the ability to
manually control how the lines are draw between them as well as
something that's going to allow me to print. I haven't been able to
figure out a way to do these things, especially since the help files in
Visio constantly generate Java scripting errors and wont display. Any
help any of you can give me would be much appreciated.
Thanks!