Access07 - Running Performance Analyzer - Suggests relate table to itself
Posted on 2014-02-02
Simple question I would think for all of you but I wanted to understand if it might be suggesting that I'm structuring something wrong.
I've been Compiling fairly often and also running the Performance Analyzer. I am only getting 3 suggestions.
One is to Save app as MDE file. (What does that really mean?)
But the one that is more questioning to me is it wants me to relate 2 of my tables to themselves.
When I look at the Analysis Notes, bot say the optimation will benefit the Query XXXX. When I look at the setup of both those queries I conclude that it must be that I am using Queries of queries of those 2 tables it is suggesting.
Thus my question is should I change something? Should I relate the tables onto themselves or should I add the Query itself to the Relationship table and then relate the table to the query?
Do those suggestions indicate something more problematic in the future?
Trying and trying to understand! Thanks in advance.