Finding Previous Invoice ID on starter solution
I've modified the invoice starter solution but I'd like to have a field in the Customer table that calculates their last invoiceID. So say Customer 3 has two invoices, #32 and #2 when I add a new invoice the "Previous Field" is calculated to be #32. I was playing with GetNthRecord but I can't filter it per customer. I'm trying to do this so I can have a portal on the invoice page that lists the previous purchase, using the filter on the portal.