Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

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

 

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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