Subject MasterLinks and to get the last records of detail query
Author kokok_kokok
I use 2 queries, a common master/detail relation.
I use MasterLinks property and everything works fine.

Now, I need to limit the number of record of the detail table to the
last 5 records for each master record. I have no idea how to do it.

If I need the first 5 record, then the solution is easy, in the detail
SQL, I put "select first 5 * from detail" and it works fine, the
problem is when I need the last 5.

Any comment will be welcome. Thank you in advance