Thanks for the reply. I have obviously not posted my issue clearly or I'm still not understanding. My relationships are indeed set up in the back end tables. If I enter the back end DB directly and look at the relationships, they are still quite intact. But those same relationships which carried over to the front end when I was designing the queries, are no longer to be found. For example I have two tables in the back end "StudentStaticData" and "StudentPerformanceData". They are linked by a primary key in the former table (StudentID) and its corresponding foreign key in the latter table. When I was initially designing the query in the design mode for the front end, as I added each table to the field lists window, they would automatically show the tables to be related. Exactly as they were when I originally set up the tables and relationships before splitting the database. Since I have moved both front and back end to a different computer and re-linked them using the linked table manager, I can go into the same queries in the design mode and the relationships between the tables are no longer there. So while the relationships appeared to be inherited just fine before I moved the database, that same inheritance is gone from my front end now.
Put another way, if I can go into my back end DB and open the relationship window and see all the intact table relationships, should I then not be able to go into the front end (which is properly linked to that back end) and open the relationships window and see the inherited relationships between tables? If so, they are not showing up. Thanks again for the help in advance.
Brian
