Hi guys, my table has a autonumber field which is used as the record ID (obviously) but also a reference number for the customer. What I want is to see the generated autonumber when i go to the "Add" page, at the moment all i get is a 0, which is updated to the next number only when the save button is pressed.
I would guess I need to use a trigger to save a new record then return to the add page for that record, but i dont know where to start, please be pretty specific with any solutions as i am not that good with php yet.
Cheers
|