I have recently upgraded my MS Access program to SQL BE and i'm trying to get a SQL trigger setup. When the tb_quotation01 table is updated i need to populate the the quotation_number with a unique number generated from the customer_code entered, a number between 001 and 999 with QU appended to to the start (eg. QU255001).
This quotation_number needs to then be returned to the original form and populated into the quotation_number filed so the user can see it.
I hope someone can assist me.