Question Create serial numbers for current database

[123dstreet]

Hi All,

Just wondering how I would go about adding a serial number sub form to my sales order form. For example, in the sales order form, when I sell 10 units of 'Product A', I want serial numbers 1-10 to automatically be created, and then stored in a table somehow. A little more complicated, when I sell 10 units of 'Product B', I want the same thing to happen, except with a different batch of a serial numbers so they remain completely seperate from eachother. Any help would be greatly appreciated, THANKS!

 

[ajetrumpet]

maybe you could use something like the attachment. the code is inefficient, but it generates product keys