lookup problem

[Robert Collins]

I have a sales database that I have written for my business (cellular phones) and have a question.

When I type in the customers mobile phone number on a new record

I would like a field to display the last date this mobile number was used.

I have created a relationship Mobile number (to) mobile number and display the creation date but it always shows the oldest record date not the last one. How to I solve this problem.

I hope I have described this clearly!

thanks for any help

[Robert Collins]

I have tried sort feature in Relationships , sorting descending date , but the problem is it looks up the very last time the number was used which is the current record!

[QuinTech]

Hi Robert, just a thought here: If all you need to do is eliminate today's date from your list of possible results, change the relationship on which the lookup is based so that it includes TO1::TodaysDate <> TO2::TodaysDate, where TodaysDate is an auto-entered date field that auto-enters creation date. That way, the lookup never returns the current date.

Does this help?

Jerry