View Single Post
  #4  
Old April 29th, 2004, 11:27 PM
Ken Snell
external usenet poster
 
Posts: n/a
Default "Relate Table X to itself" ???

Gary -

My answer may not be appropriate for what you're seeking.... I misunderstood
your question when I first read it... you're not asking why there is a
relationship between the table and itself...you're wondering why the
Analyzer is suggesting that you make a relationship and I have not seen that
"behavior" before.

Sorry.

--
Ken Snell
MS ACCESS MVP

"Gary Smith" wrote in message
...
Ken--

I'll check into that. Thanks.

--Gary
-----Original Message-----
Do you have a query that has a self-join for tblTasks to

itself? Such a
query will create a relationship in the background.

--
Ken Snell
MS ACCESS MVP

"Gary Smith" wrote

in message
...
Hello--

Whenever I run the Performance Analyzer I get the
following "suggestion":

Table 'tblTasks': Relate to table 'tblTasks'

Why is it telling me to relate a table to itself? What
should I do about it?

As always, much appreciation for any assistance that may
be forthcoming.

--Gary



.