Finding next number from a string

[njw89]

Hi guys/girls, first post, great forum.

I have a problem, and I am not sure where to ask. But I will try here.

I have a column in a table which stores a barcode number. This is in the format LL00000

The LL being a code for the item in question, and the 00000 being the specific number given to the item in question.

Now, my idea is that if I was to get a heap of these items in stock, I am trying to make a form which can let me pick which Item it is, then it shows the next available number for use, then I have another field, which tells me how many of this item to make.

For example, if I have a heap of Mouse Pads or MP's, already in stock, so MP00001, MP00002, MP00003, how can I make it come up with the next number available(MP00004) in the field, so then in the numberToMake field I can type in 10, and it will automatically create MP00004 through to MP00013?

Thanks For the great advice in your forums, keep it up!

Cheers

Nathan

 

[HiTechCoach]

Nathan,

Is this a multi-user (split) databases?

What you have described sounds like serialized inventory.

If that is true, you should be creating a new record for each new item/number.

Is this what you are doing?


These might also help:

DMax Plus one for use with differing categories.

and

How to Create an Incrementing Record Number

 

[njw89]

Im not entirely sure about the terminology you are using, but it is a 1 user account system, and there is a record stored in the "items" table for each and every item. My system is basically exactly the same as a library, items likes books, cd's, dvd's all have different barcode systems, CD00001 would be the barcode number for the first CD in the stockpile DV00001 would be the first DVD, BK00001 would be the first Book. But, like I said, I am not entirely sure.