The correct name is ZLastDate.

If a new transaction for a particular Customer is entered then the Transheaders table should fire the Trigger and update only that Customers record. (As in if a new invoice is posted this will update the transheaders table)

Thanks.