Linked Table Relationship Not Visible in Front End

[Tom]

All,

I recently added a new table in the back end of a split Access
database, added a one-to-many relationship, then linked the table to
the front end. The new table appears, and the data is intact, but the
relationship did not make it through the linking process. Nor can I
re-create the relationship in the FE.

What am I missing?

Thanks,

Tom

 

[John W. Vinson]

All,

I recently added a new table in the back end of a split Access
database, added a one-to-many relationship, then linked the table to
the front end. The new table appears, and the data is intact, but the
relationship did not make it through the linking process. Nor can I
re-create the relationship in the FE.

What am I missing?

Nothing, most likely. Relationships exist only in the database where the
tables reside. The Relationships window in the frontend is just informative,
not authoritative.

You could try opening the relationships window and clicking the "show all
relationships" icon; or at worst, open the front end, delete both tables (fear
not, you're just deleting the link not the table), and using File... Get
External Data... Link to relink them.