Serial Numbers!?

[123dstreet]

Hi All!

I am trying to create a query to add in Serial numbers. In my Sales Order Details Sub form, I choose the Product, and the Quantity of that product that I am going to sell. I basically want a new form to open after that product has been selected, and in that form I want one record for each of the products. ex. I sell 5 units of product A. After Product A is chosen, on the new form, I want 5 records, each having a unique serial number. Is there anyway to have it automatically create those 5 records?

Any thoughts or input would be greatly appreciated! Thanks!!

 

[dkinley]

Yes, it is possible.

The question is -
(a) Are you creating the serial numbers on the fly and you create the metal stamp for the product then, or
(b) is it going to grab them from somewhere else and then you dig through the boxes looking at the box labels to ensure you grabbed the right serial numbers to send, or
(c) you just want it to create n new records and then you fill in the serial numbers at a later time?

-dK

 

[123dstreet]

I want to create n New Records and have the serial number be an autonumber that fills in for each record. so it is basically on the fly, we are not worried about the metal stamp at that point in time. I basically need one new record for each unit that we make/sell so each unit has a different serial number, but I want the records to create automatically based on the Qty of units are on the order.

 

[dkinley]

Okie dokie ... I have my method of doing it but discovered another way that was posted not too long ago that might be of better assistance.

I will have to search through the forums for the appropriate thread - give a few moments ...

-dK

 

[dkinley]

Ah .. found it.

This might be overkill for what you are doing, I am not sure of your underlying structure, etc., but you should be able to get the gist of it.

Take a look at this thread. You would definitely have to mod the WHERE statement in the function posted by VBAInet (post #11).

The point being, you will need to create those records and have them link back to your original primary keys - thus this cloning method.

HTH,
-dK