going to last record in a find

[zekewalton]

I have a script in my db that searches on a name field and then sorts on a calculated field (NAME & COUNTER). After I do the find and get the records I want displayed, I need to go to the last record in the find and use data in it to create a new record. When I use the Go To Record/Last function it goes to the last record in then database and not the last record in the find. For example, I have 5 records in the db and they were entered in the following order JIM 001, JIM 002, JOHN 001, JOHN 002, JIM 003. When I search for John I get 2 records for John. The Go To Record/Last command in the script moves to the JIM 003 record. I need to duplicate the JOHN 002 record for the new record. (JIM 001 is a calculated field based on NAME & COUNTER.) I need the script to go to JOHN 002, increment the counter to 003 and calculate the new record number to JOHN 003.

Any help you can provide will be greatly appreciated.

Thanks

Zeke

[zekewalton]

Got it to work, Had the sort function wrong.

Zeke

[zekewalton]

OOPS,

I thought it was workin but now it is not (working graveyard shift can really mess up your thinking processes). If anyone can steer me in the right direction I would greatly appreciate it.

Thanks,

Zeke

[LiveOak]

Something else is wrong with your script. The Go to Record/Request/Page(last) command goes to the last record in the sorted found set. I think you have a case of "something you know, ain't so" .

-bd

[zekewalton]

Got it working. Deleted the script and started over again from scratch. Not sure what I ahd wrong but it probably had something to do with too many graveyard shifts and.or too many double shifts. Thanks for helping.

Zeke