# Re: How to make Index on record???

Posted by David Wong on August 10, 1998 at 15:20:02:

In Reply to: How to make Index on record??? posted by Shih Yao on August 10, 1998 at 13:51:04:

You can define a new table to store te maximum no. for each country. I used this method in a Access project before.

: Someone can help me??? My problems is like: -

: I have created a label called "lblIndexDisplay" and I want computer will generate index number to each record(I have created a
: database with Microsoft Access)on "lblIndexDisplay".....

: The Index Number for generate automatically will according to Country(3 Country I have created....CHINA, HONG KONG, TAIWAN)
: . For example, China record with Index No. beginning with CHI001, Hong Kong record with Index No. beginning with HK001 and
: Taiwan record with Index No. beginning with TW001.... So, How I coding with this situation???
:
: I hope somebody can help me!!! I dun't know how to code this situation.....Please help me.... Thank you!!!

: * I'm very sorry about inconvenience for everyone becoz I'm wrote in English... I just can view Chinese word with MagicWin....
: Sorry to all!!!

Follow Ups: