Jump to content
Salesforce and other SMB Solutions are coming soon. ×

How accelerate calculations


Recommended Posts

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



Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use