Let we have two tables clients and orders. We need to know from a portal the specific record number with GetNthRecord(orders; x) x=last record number of the client (last order).

but how can we know x if in orders table write many clients and not just one?

Pascal

I'm not quite sure I understand, since GetNthRecord doesn't return a record number.

If you need to get data from the LAST related record, you can use the... well, 'Last' function. The only difference is that it will return the last 'not empty' value.

This function is categorised as a 'repeating function', but it is much more than that.

First I want to thank you for your answer.

To explain:

Last function is good but the concept here is to get any value of a field of any record inticates x. For example if you want to get last-1 in dispersional records of different clients. If your client have five orders and the clients are 400 hundreds, of course you have problems to nominate the 4th order of your client if the orders table have 2000 records. The real problem is define the x number of a specific order for that client. It is like first to find the records then nominate the forth order but how can we do this with a calculation, it is difficult find and nominate. I hope you can understand, I may explain more...

Pascal

I don't quite follow, but maybe this is what you're looking for.

This is the exact solution!

Thank you a lot, comment.

Pascal