Access 2010 web Database thru Sharepoint (1 Viewer)

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!
 

Users who are viewing this thread

Top Bottom