S
Steve Schapel
Squirrel,
Yes, you are just storing that number in the field. So they will be
repeated every month.
The other stuff about the "BC" and the date reference and the "-" are
all for display purposes only, you won't be storing that in the table.
Well, the "yymm" is already stored in the table, in the DateNotified
field, so you don't want to store that same information in more than one
place. And the "BC" is the same for each record, so it's pointless
storing that. Even if you were to store it, it is a separate data
element, and therefore would need its own distinct field. So all you
are storing is the monthly serialising number.
Yes, you are just storing that number in the field. So they will be
repeated every month.
The other stuff about the "BC" and the date reference and the "-" are
all for display purposes only, you won't be storing that in the table.
Well, the "yymm" is already stored in the table, in the DateNotified
field, so you don't want to store that same information in more than one
place. And the "BC" is the same for each record, so it's pointless
storing that. Even if you were to store it, it is a separate data
element, and therefore would need its own distinct field. So all you
are storing is the monthly serialising number.