Getting the next ID before insert
Hi quick question. I want to get the ID of the next record before inset.
Reason, I want to create a product record which upon form submit will store the ID of the record in another table for product images, now since the product hasnt been created until the form submit is pressed, I need a way of getting the next record ID. What would be the syntax for this?
In essence, I need, [latest ProductID]+1
Chris