Hello
I am working on a project (due today) where we have a form that populates the orders table. They now want the order number field(O_Num) to be randomly generated.This also happens to be the primary key the number should start with a T or G, then generate a 4-5 digit number. We already have an autogenerate number on this table so it wont let me use that setting. Any suggestions would be GREATLY appreciated.