npresadbukka
New member
- Local time
- Today, 13:56
- Joined
- Dec 4, 2013
- Messages
- 1
I am New to Access 2010 web database.
While creating an access database where Unique ID to be work.
My main table will have each record (tbl_import) has the following fields:
ID (Primary Key)
Segment - Combo Box
Port - Combo Box
MOT - Combo Box
Ref No
Segment - Combo Box will have -
REW
WTT
DBM
Port - Combo Box
MAA
MUM
DEL
KOL
VZG
MOT - Combo Box
Air
SEA
COURIER
Ref No: - i require Unique autonumber based on the Segment
So based on segment field which I choose
Development autonumber has to set REW-1001 and WTT has to set WTT-2001, DBM DBM-3001
My thought is if there a way in Data macros to run at the segment combox box on 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 Port field and MOT Field
Ex : - REW-1005/MAA/AIR
WTT-2007/MUM/SEA
DBM-3001/DEL/COURIER
I appreciate any thoughts!
While creating an access database where Unique ID to be work.
My main table will have each record (tbl_import) has the following fields:
ID (Primary Key)
Segment - Combo Box
Port - Combo Box
MOT - Combo Box
Ref No
Segment - Combo Box will have -
REW
WTT
DBM
Port - Combo Box
MAA
MUM
DEL
KOL
VZG
MOT - Combo Box
Air
SEA
COURIER
Ref No: - i require Unique autonumber based on the Segment
So based on segment field which I choose
Development autonumber has to set REW-1001 and WTT has to set WTT-2001, DBM DBM-3001
My thought is if there a way in Data macros to run at the segment combox box on 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 Port field and MOT Field
Ex : - REW-1005/MAA/AIR
WTT-2007/MUM/SEA
DBM-3001/DEL/COURIER
I appreciate any thoughts!