Subject | MasterLinks and to get the last records of detail query |
---|---|
Author | kokok_kokok |
Post date | 2007-10-17T15:58:41Z |
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
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