I have a vfp 6.0 table that contain date senstive entries:

Table name: SearchTrack.dbf
search_name
search_desc
search_date

The max searches a user can have is (4), so when the user tries to search a 5th time, i want to grab the record with the latest search date and simply replace the search name, desc fields as well as update the search_date field with the new system date.