If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Relate Table X to itself" ???
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 |
#2
|
|||
|
|||
"Relate Table X to itself" ???
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 |
#3
|
|||
|
|||
"Relate Table X to itself" ???
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 . |
#4
|
|||
|
|||
"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 . |
Thread Tools | |
Display Modes | |
|
|