I have tried the link to faroukmusa as advised by a response to a previous thread "Visio Database Table Linking & Dynamic Updating" and can now reverse engineer a database in a few minutes! I'm impressed as it would have taken me a day to analyse and draw.
Does anyone know how to automatically add the entity relationships to the diagram and hopefully be able to diagramatically show all the linkage between tables and queries to show data flow through the database? I do not realy need to modify the database at this stage though I can see it may be a useful feature in the future.
TIA Alex
Does anyone know how to automatically add the entity relationships to the diagram and hopefully be able to diagramatically show all the linkage between tables and queries to show data flow through the database? I do not realy need to modify the database at this stage though I can see it may be a useful feature in the future.
TIA Alex