If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked Table Relationship Not Visible in Front End
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 |
#2
|
|||
|
|||
Linked Table Relationship Not Visible in Front End
On Tue, 14 Oct 2008 14:43:29 -0700 (PDT), Tom wrote:
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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|