assigning serial numbers

[kwightman8874]

I am working in MS access.I have a part number and i want to assign serial numbers to it. for example i have a part number 1111-12114-01, I want to assign 5 serial numbers to it, example 001,002, 003, 004, 005. I then have another part number and i want to assign another 5 serial number to it. It continues from the last serial number used. So what i want is to put a part number in a field and then the quantity field for that part number to auto assign serial numbers for the quantity requested. I hope i got that right!

 

[dhookom]

Please provide your table and field names. Are you generating new records in a table based on the quantity field?

Typically you should start by creating a table of numbers [tblNums] with a single numeric field [Num] and numbers 1 through your maximum quantity. You can then create a query to generate sequential numbers.

Duane
Hook'D on Access
MS Access MVP

 

[LouieGrandie]

You would need two tables. One for I would assume warehouse detail which would hold the total quantity on hand. You would also need an Item Costing Table which would have as it's key fields, Item Number, Warehouse Number and Serial Number. This would link to your Warehouse detail on Item Number and Warehouse Number. As you use or sell a serial number you would need a way to delete the record in the costing table and update the quantity total in the warehouse detail.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[SkipVought]

What is the purpose of assigning a serial number?

Why only up to FIVE serial numbers? Could there not be more than 5?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]