Showing the last record of the table on to the form

datha91
Member Posts: 7
Hi everyone. I am still at the learning stage of NAV development so I have this beginner problem which I have tried to solve but to no avail.
Shedding me some guidance would be greatly appreciated.
So here is my problem.

As you can see , the form "particulars" show up the records from the table "particulars".
My problem is that upon the form startup I want it to show the last record in the table , in this case it will be John, instead of David.
So i went about doing a FINDLAST() as follow in the form.

I have tried it in the table too. But it doesnt work.
I know it is a small problem but it sucks when I am self-learning and have no one to turn to.
Thanks in advance guys. And Merry Christmas to all of you
Shedding me some guidance would be greatly appreciated.
So here is my problem.

As you can see , the form "particulars" show up the records from the table "particulars".
My problem is that upon the form startup I want it to show the last record in the table , in this case it will be John, instead of David.
So i went about doing a FINDLAST() as follow in the form.

I have tried it in the table too. But it doesnt work.
I know it is a small problem but it sucks when I am self-learning and have no one to turn to.

Thanks in advance guys. And Merry Christmas to all of you

0
Comments
-
Set SourceTablePlacement property to Last in form and try0
-
Oh my god it works like a charm!
Thank you so much Mohana.0 -
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions