Auto Incrementing A Field

[cpsqlrwn]

I have an Item table where the field Item, a text field, is the Primary Key. I have 2 kinds of items which are identified by a boolean field, raw materials and finished products. What I want to do is to create 2 forms for adding new items, one for finished products where the item is keyed in by the user, and one for raw materials where the item is auto incremented. Raw materials are tracked by description, the number is irrelevant, and users need not be involved in the number assignment. Can someone help me with creating an auto increment condition for an indexed text field? Thanks in advance!

 

[MichaelRed]

(Advanced)search on "increment" should produce a plethora of responses. some may refer to incrrementing a string and may even include a procedure which illustrates the technique. might also try increment string




MichaelRed