hi everybody , i need to solve this case as soon as possible :
i have the master table that include the following data :
(SerialNo - integer (P.K), civil-bit, mechanical-bit, etc)
and form that include the serial no text field that automatic increase by one each time the user click the new button what i need is when the user check the Civil check box the serial start from 1, when the user check on mechanical the serial should reset to 1 and continue, how i can do this witout change the structure of table , help me please ???