Hi
I am building a protocol database.
I have a table where I have a automatic generated ID number. And I have the 4 types of protocol (A, B, C, D).
I have 4 fields that are "Number for A", "Number for B", "Number for C", "Number for D".
I want to make the first field in ID that has protocol A to be number 1 in "Number for A" and so on. The same thing for B, C and D.
Thanks!!