I have 3 tables. The 3 tables are related to each other. For instance:
Table 1:
key1
text1
number1
Table 2:
key2
text1(from table 1)
yes-no
number2
Table 3:
number2 (from table 2)
description1
description2
I need to create a data flow diagram of the DATA within these tables. I created a query in access tp give me the join of the 3 tables. I then used the “Reverse Engineer” feature in Visio, but that shows the relationships between the table structures (i.e. it shows me the schema of the tables) and not the data that I have stored within these tables. Is there a way for me to create the required relationship diagram of the data?
Thanks
