I have customers and site reports tables. Engineer visit customer and do a site report.
On the customers layout, I would like to show the last site report visit date. There is a creation date field in my site report table. I would like to show the last site report on customer layout.
When I select different customer or go to next customer, the site report date should effictively change and refelect to selected customer.
I created "LastVsit" calculation field in my site reports table and wrote this calculation. But it says '?' on layout.
WHERE complete = 1
Order BY CreationDate Desc
FETCH FIRST 1 ROWS ONLY
; "" ; "" )
My question is what would be best way to display the last site report date on customer layout.