how to create in FM Pro a search equivalent to SELECT TOP in SQL
I'm new to FM Pro and I have been doing pretty much all I need, but I'm struggling with one particular search.
Here is what I have done:
I have a Layout in my main project reading values from table (JOBS), I have a relationship with another table (TASKS) that i present in a portal.
What works so far:
I can search for all records in my JOBS DB that have a particular value in (TASKS::TASK_DESCRIPTION)
What I want is to show only the result only if the value in TASKS::TASK_DESCRIPTION with the most recent date inserted.
I have attached a screen shot of a unwanted search result.
I would fin the value in SQL with SELECT TOP, but I dnot' seem to find the way with the scripting tool.
Any suggestion is appreciated.