Computer Science, asked by sumanajayyadav2, 7 months ago

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

Answered by smitakumarigaya20
4

Answer:

hope it's help

Explanation:

please mark as brainliest

Attachments:
Answered by aadieaadie93
2

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.

Similar questions