"Relate Table X to itself" ???

  • Thread starter Thread starter Gary Smith
  • Start date Start date
G

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
 
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--

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>




.
Click to expand...
 
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.
 
Back
Top