How to select the max value of a field in another table

[#1]

Hi,

how I select the minimum and maximum START_MONTH per Customer (see attached small sample)?

Problem is, that the customer is selected via webticket on the access point, so I need an expression after the load that sets a variable.

Thanks.

[alexandros17 · Accepted solution]

If only one customer is selected, when you open the document you have that selection that works on the date so simply using min and max you obtain the result

if you want to have min and max for all customers tìyou can do it in the script.

[#3]

Yes, you are right. Currently it does not work in my real application, but this seems to be a side effect from all that trigger stuff that is running at the Open document event. Will need to debug this.

Thanks!