Relationship flow chart not appearing

Occasional Contributor

When I used Access as the back end for my database, I would click onto Database Tools then Relationships and would get a flow chart of all the my tables and all the relationships:  ie one-to-many, etc..  The Database Documenter would also list the relationships.

Now that I use SQL Express Server as the back end for my database, when I open Access and click onto Database Tools then Relationships my tables appear without the relationship flow chart.  The Database Documenter does not list any relationships.

Amy I doing something wrong. 

I thought that the relationships were transferred with the tables to the SQL Server.

 

0 Replies