Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Last Record!
- Thread starter Deverton
- Start date
The answer depends on what you mean by the "last record". If it has a unique ID you could put that value into a variable-type field and use a FIND with that variable to locate it. Or you could set up a one-record control database to hold the unique ID and join it to the record. Update the control database record when another record is added and the join will show it to you.
The problem is that the "last record" changes if you sort the database or have a "found set" that does not include it. So you need some way to identify uniquely each record. If you do not have a unique ID, you can add a serial-numbered field for that purpose.
Sue Sloan
The problem is that the "last record" changes if you sort the database or have a "found set" that does not include it. So you need some way to identify uniquely each record. If you do not have a unique ID, you can add a serial-numbered field for that purpose.
Sue Sloan
- Status
Similar threads
