I am new to toad data modeler. I just joined a new group and they have a huge oracle database which has absolutly no foreign keys. using toad data modeler i have placed everything into paper and spent several days finding the relationships between tables.
Here is what I am trying to do. I want to sort of graphically show the relationships. but I don’t just want the table relation ship but also the field relationship.
As an example :
Lets say you have table invoice header and table invoice detail. They are connected by invoice id. So i would like to show a relationship between invoice header and invoice detail with a line which connects the invoice ID from header to detail. Can this be done? Sounds pretty simple to me just can’t figure out. I am able to create a relation ship but the relationship just joins the tables (visually does not show which fields are connected), I like to show a line from one field to another so that it becomes obvious that the fields are linked.