Originally Posted by
Ajax
simple issue is so many tables, so little room. Just because the tables are not visible in the relationships window does not mean the relationships do not exist. You can also investigate using the documenter or the contents of the msysRelationships table for further documentation.
If your db design is now stable and you are looking for a graphical view of the whole domain, then what I have done in the past is to take a related group of the tables (e.g. group1 invoicing, group2, stock control, group3 employee management, etc) and display on screen as required then take a screenshot and save the image. Do the same for the other groups. Where a table appears more than once (e.g. stock table appears in stock management and invoicing groups) then do so. Then in word or excel (I prefer excel) copy the images and layout as required. Then use shapes to draw connecting lines. Needs some working on (suggest use pen and paper initially to get the general layout) and will take time.