Hi ,

Am Anil, i need help writing a trigger program


I have Contact Table like
Primary key (ID)
unique ID (MMS_ID)
ID Name MMS_Contact_ID

1 A MMSC0001
2 B MMSC0002

when am inserting ID and Name Columns Data like as 3, C
then automatically increase the MMS_ID Column like MMSC0003(But am not inserting the MMS_Contact_ID) it should automatically genrated MMS_Contact_ID value......

Please give me a replay ASAP


Thanks in Advance