Custom Autonumber based on lookup

[npresadbukka]

Custom Autonumber based on lookup

I am creating an access database where autonumbers to be work.



I have a table with Segment Name my main table will lookup the values of segment table.

Based on the Segment I choose Autonumber has to be created

My main table to house each record (tbl_import) has the following fields:

ID
Segment
Port
MOT
TOTAL CIF

Child table - Segment contains
Development
Deployment
Testing


So based on segment field which I choose

Development autonumber has to set DEV-1001 and Deployment has to set DEP-2001, TEST-3001

My thought is if there a way to code the Segment field to lookup the segment what I choose based on the Autonumber series starts (similar to a vlookup in excel), then concatenate the DEV in the Record ID field.

Can someone help? I am not very good with VBA (can edit fairly well but not proficient at writing it)

I appreciate any thoughts!

[RuralGuy]

Maybe this link will help: http://www.baldyweb.com/CustomAutonumber.htm

[June7]

Creating custom unique ID is common topic. Search forum or google.

Here is one: http://forums.aspfree.com/microsoft-...ta-403208.html