Linked Table Relationship Not Visible in Front End

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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?
Click to expand...

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.
 
Back
Top