Hello...
I have a very large table with three fields, SSN(C), enter_date (datetime) and complete (logical). I am wanting to build an index which would provide the fastest performance with the seek command. My goal is to locate any matching social security numbers, with a complete file (.t. in complete) that have already had an application entered within the past 90 days using enter_date. (There could be more than 1.)
Any suggestions?

Thanks very much for your time.