Where did you create this relation?
Relationships on the Tools menu?
Or just in a query?
Are these local tables (in the database)?
Or are they attached tables?
If attached, you need to create them in the back end database (i.e. the
database where the tables actually reside.)
Try clicking the Show All button on the toolbar in the Relationships window.
Is there any chance the tables are in the Relationships window, but off
screen? This can happen if you change screen resolution, orientation, or
have used multiple monitors.
If none of these occur, it's possible that something is corrupt in the
database. To fix it, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
Then compact the database:
Tools | Database Utilities | Compact/Repair
Still stuck? Loop through the Relations programmatically to see if the
relationship actually exists:
Public Function ShowRel()
Dim db As DAO.Database
Dim rel As DAO.Relation
Dim fld As DAO.Field
Set db = CurrentDb()
For Each rel In db.Relations
Debug.Print rel.Name, rel.Table, rel.ForeignTable,
RelationAttributes(rel.Attributes)
For Each fld In rel.Fields
Debug.Print , fld.Name, fld.ForeignName
Next
Next
Set fld = Nothing
Set rel = Nothing
Set db = Nothing
End Function
