Hi,

Can someone help me or show me step by step on how to do this?

My problem is that I have a database which hold information that was sent from a form. What I wanted to do, is to display the last record in the database first on my "display" page. For Instance, I have 3 record in the database and I want to display only the last record (which is 3) in my "display" page. Then the user can use the navigation link to move from one record to the next. Please help...

Thanks a lot.
Dave

Dave,

you need to find out (or define) wich field of your database table defines the newest record. Very often this is the one with the highest id. But it can also be the one with the latest date value in a specific column.

To achieve what you are describing you should make a recordset and then sort it on that specific field. (at the bottom of the basic recordset dialog box). Order DESCENDING and then you can achive what you want to do using Tom Mucks Data Navigation sute that is available at www.basic-ultradev.com

Waldo Smeets - www.UDzone.com Webmaster
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

Waldo,

Thanks you! I got it to work! =)