Extends a table issue

Sarah Bouil
Tera Expert

Table A -> 2 Fields Table A5 and Table A1 etc

 

Table D-> 2 Fields Table D1 and Table D2

 

Table D is extended from Table A

 

So if I create a record in Table D, the record is creating in Table A and Table A5 field is increasing? Table A5 is a Number Maintenance, but Table A5 should not increase when I create Table D record right 

 

SarahBouil_0-1741474921499.png

 

6 REPLIES 6

Shivalika
Mega Sage

Hello @Sarah Bouil 

 

Please go to sys_number [Number maintenance] table. Find the record for Table A5 and check if "Applies to all child tables" is enabled. If it is please disable that. 

 

Additionally since , you have inherited table D from Table A, all the fields which are Table A will automatically come in Table D. 

 

Please mark my answer as helpful and accept solution if it helped you in anyway. 

 

Regards, 

Shivalika

 

LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

YouTube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=XhGtosbatku9yxdH

Dr Atul G- LNG
Tera Patron
Tera Patron

HI @Sarah Bouil 

 

https://www.servicenow.com/community/developer-forum/possible-for-child-table-to-utilize-auto-number...

 

 

Yes, in ServiceNow, a record created in an extended table will also create a corresponding record on the parent tableThis is because the extended table inherits fields and properties from the parent table

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************