Access Relationships can't see them all

[ontopofmalvern]

Hi
I have a database that has grown to have over 60 tables and a considerable number of relationships. I want to review the relationships as when I started this project I didn't really know what I was doing and want to go back and check it is all robust.

When I go to look at relationships I cannot scroll up the page to see one at top. I know there is a workaround to this problem (hide all the tables one by one then show all tables as described here <https://answers.microsoft.com/en-us...p-tables/17607477-04ec-4808-a9fd-dbc4011c211d>).

Not only is this clumsy I am wondering if there is better way of looking at it now it has got quite biggish, is there some why of generating a report that shows all the relationships in a table format that I can systematically go through? The grahical format Access offers is nice when it is a smallish project but not great when you can only a third of the tables at a time.

Many thanks
Richard

 

[isladogs]

If you have A365 you can now lasso all the tables and move them downwards at the same time.

As for your other questions, you can create a query on the system table MSysRelationships and then generate a report from that.
For more info on managing relationships, see my extended article at http://www.mendipdatasystems.co.uk/relationships1/4594533224

 

[ontopofmalvern]

That looks just the ticket. My follow up question was to be how to edit links without the relationship window but you've answered that before I got there.
Many thanks