multiplex77
Programmer
Hi,
I have taken over an Access 2000 database with 67 tables and infinitely many relationships (or so it seems like). When I do Tools -> Relationships, I see all the tables, but a very messy array of table relationships that looks like a spiderweb. Is there a way to view the relationships in a more human-readable layout? Can I give a command to SPREAD out all the tables so that they aren't crunched up together?
How about just a list of the tables, their field names and the relationships they have with other tables/fields?
I've tried looking in the Access help but can find anything that facilitates this. Does anyone have any suggestions?
Truly appreciate any help rendered.
I have taken over an Access 2000 database with 67 tables and infinitely many relationships (or so it seems like). When I do Tools -> Relationships, I see all the tables, but a very messy array of table relationships that looks like a spiderweb. Is there a way to view the relationships in a more human-readable layout? Can I give a command to SPREAD out all the tables so that they aren't crunched up together?
How about just a list of the tables, their field names and the relationships they have with other tables/fields?
I've tried looking in the Access help but can find anything that facilitates this. Does anyone have any suggestions?
Truly appreciate any help rendered.