marysilvaramos Posted December 4, 2001 Share Posted December 4, 2001 Hi All: I have a table "B" where I record all the letters that have been sent to the patients. This table has a field that show me when the special letter was sent for last time (maxdate).It is calculation (Max(date)). This table (B) is related with another ("A") through the SS# (this is the main table). This one has 8,000 records now. Weekly, I need a patient list of who hasn't received the special letter. I do a find in the Table "A" through the field in the Table "B" (maxdate). The search take several minutes because of the amount of records... What can I do to accelerate the search? Thank very much Mary Quote Link to comment Share on other sites More sharing options...
Anatoli Posted December 4, 2001 Share Posted December 4, 2001 Couldn't you just use portal technique? It will be much faster. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.