I've been asked to created a program for my local video rental shop, that can store the details of the members, videos, dvds etc. On the for were the user adds a member, I am wanting some code that will generate the membership number automaticaly in a edit box. E.g. the firs member would have the membership number "0001", when I add another the membership number would be "0002". Other words the membership number goes up by one each time.
Could someone please help me.