Hidden Relationships

  • Thread starter Thread starter ITMA
  • Start date Start date
I

ITMA

Can someone tell me what the criteria is for Access displaying a
relationship in the Relationships window? I mean, some relationships seem
to exist but are never shown here even when clicking Show All. If you use
the Lookup Wizard in a table then sometimes the resulting relationship is
shown in the Relationships Window, ... sometimes not. Can anyone shed any
light on any of this?
 
Can someone tell me what the criteria is for Access displaying a
relationship in the Relationships window?
Click to expand...

maybe... but they are working at Microsoft and probably are under NDA
and aren't allowed to.

In my experience the relationships window is peculiar and unreliable.
Sometimes SHOW ALL works; sometimes you need to select each table in
turn and select SHOW DIRECT; sometimes even that doesn't work.

I've written some VBA code to display relationships in text form, and
surprised myself a few times with its results:

Sub ShowAllRelations()
Dim db As DAO.Database
Dim rel As Relation
Dim inti As Integer
Set db = DBEngine(0)(0)
For inti = db.Relations.Count - 1 To 0 Step -1
Set rel = db.Relations(inti)
Debug.Print "Relation "; rel.Name, rel.Table, rel.ForeignTable
Next inti
End Sub
 
Back
Top