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.
