"Relate Table X to itself" ???

[Gary Smith]

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

 

[Ken Snell]

Do you have a query that has a self-join for tblTasks to itself? Such a
query will create a relationship in the background.

 

[Gary Smith]

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>




.

 

[Ken Snell]

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.