View Single Post
  #1 (permalink)  
Old February 28th, 2008, 02:00 PM
mfahmyg mfahmyg is offline
Registered User
 
Join Date: Feb 2008
Location: kajang, selangor, Malaysia.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default AUTO FORMAT field

Hi Friends...

I have a problem... I create a field named member_ID(primary key) in a table called TMEMBER. The field format is AAAA-08-00000001.
"AAAA" - fixed alphabet.
"08" - year (change when comes to a new year)
"00000001" - add 1 to each new record. If record no 10 -> "00000010".

The problem is that I do not know how to make the member_ID field automatically appeared and calculated on each new record. Let say, I create a new record (record no.2), previously record no.1...
Previously, the member_id is "AAAA-08-00000001", when create new record, the member_ID field should automatically appeared "AAAA-08-00000002" but it didn't. That includes the year "08", if current year is 2009, the middle digit should appear "09".

Need help from expert friends in this forum...

Thanks & regards,
- FAHMY -
Reply With Quote