I need to have my serial numbers update with a special designation at the beginning of a particular record. I have several categories of video tape that need to be put into a database. We would like the different types of tape to be designated with a certain code at the begining such as DV- for DV tapes and MINI- for MiniDV. I deally the client would like to be able to select the type of media either from a radio button or a pull down menu, at this point the serial numbering system would auto update the beginning designation to reflect the type of media selected.

I'm closing this topic as it was posted in another forum.