MS Access analyzer and optimizer

[geralf]

Hi,

Does anyone know why the analyzer tool suggests to make a relationship to it's own table?. If I do this optimization, the table is added once more in the Relationship window, and gets the MyTable_1 extension?

Thanks in advance

 

[Mile-O]

Most likely it sees a relationship whereby a value is "recursive" in that it stores a value within its field from elsewhere in that table.

i.e.

tblPeople
PeopleID
Forename
Surname
ManagerID


where ManagerID could be any of PeopleID

 

[mission2java_78]

Hi,

Does anyone know why the analyzer tool suggests to make a relationship to it's own table?. If I do this optimization, the table is added once more in the Relationship window, and gets the MyTable_1 extension?

Thanks in advance

The analyzer is stupid.