Hey folks,

I've been trying to keep my main DB application below 2 GB, so I've been moving subrecords to an alternateserver with their owns standalone applications.

However, I'm certain I can prevent an alternateserver xlookup every time i flip records, which will speed things up -- I just am not sure how to go about it.

If I have an alternate database with payment records (about 400,000 to start), how can I simply lookup and track the most recent payment in that database once?

If I can do that, I can make my alternateserver lookup routine conditional on a file assigned before that payment date only ...

Thanks!