I need to update a field in my tbl_reference table once a new record is added. The field is going to be used by users to identify each record. The field name is unique_reference and needs to include
and an increasing number 0001
The first half before the "/" is the batch_reference field and I was trying to base the "0001" part in the ID field which is an autonumber field.