In the Number data field, a unique sequential increment by 1 is automatically
inserted when a record is added, or decremented by 1 when a record is deleted.
Answers
Answer:
hope it's help
Explanation:
please mark as brainliest
Answer:
Example
To borrow from the thread that inspired this endeavor
52, say you're building product codes that have a
variant sub-code, and want that sub-code to
automatically increment each time an item of a given
product code is added in a new record. However, it
needs to auto-increment each product's sub-code
separately, even when product codes are added out
of order.
For example, the first product code is 001, and its
initial sub-code is 1, so the full combined code is 001
1. When you add a new variation of product 001, the
sub-code bumps up by 1, creating 001-2.
Now a new product is introduced with code 002.
Because it's the first of its kind, its full combined
code is 002-1. If we then introduce a third variant of
product 001, it would end up with a combined code of
001-3.