Hi everybody
I need to generate a customize autonumber for my fields
I got MovieID field and MaterialFormat field which is optional with "DVD, VCD, BetaTAPE, VHS Tape" and by choosing each one of them I need to generate the number like this for MaterialID field.
<MovieID>"-"<10000 for DVD, 20000 for VCD, 30000 for BetaTape,40000 for VHS Tape> <autonumber>
thanks alot
PS: is there any space in here to upload my database ? its only 250 kb
I need to generate a customize autonumber for my fields
I got MovieID field and MaterialFormat field which is optional with "DVD, VCD, BetaTAPE, VHS Tape" and by choosing each one of them I need to generate the number like this for MaterialID field.
<MovieID>"-"<10000 for DVD, 20000 for VCD, 30000 for BetaTape,40000 for VHS Tape> <autonumber>
thanks alot
PS: is there any space in here to upload my database ? its only 250 kb