Coding an index

So i have a list of vendors all with a unique alpha-numberic code as the index. the code is the first letter of the vendor following 0001,0002,0003 etc. Is there a way i can code the index column to automatically do this?

[221 byte] By [SwordSainTII] at [2007-11-11 10:07:08]

«« char & int
»» Applet

# 1 Re: Coding an index

It would probably depend upon the database you are working with. You can use an INSERT trigger if this feature is supported.

pclement at 2007-11-11 23:43:26 >

# 2 Re: Coding an index

This is MS access 2007

SwordSainTII at 2007-11-11 23:44:32 >

# 3 Re: Coding an index

Can you use that function in access?

SwordSainTII at 2007-11-11 23:45:30 >

This is a Technology portal site for all the developer, It's a community, here you can post your question when you are learning, working, and soso...we'll make it better than yesterday Everyday...

Coding an index

Developer Tech

All Classified

Developer Tech New Topic

Developer Tech Hot Topic