Possible for child table to utilize auto-numbering of parent table instead?

Bob Loblaw
Mega Guru

Hi - I am fairly new to ServiceNow, so bear with me....

I have created Table A which extends Table B. I have deselected the auto-number option on Table A in hopes of using Table B's auto-numbering system for records created in Table A.

Since Table A extends Table B, it would make sense to me that Table A can also use Table B's auto-numbering system as well. But I've been wrong before...

I've read over Auto Numbering for extensible table article but wasn't sure that had the answer I was looking for.

Is this possible and if so, how? Any tips would be appreciated - thanks!

1 ACCEPTED SOLUTION

Thanks for the information Trace.



If you have validated there is no record for tableA in sys_number, check to see if there is an entry in sys_number_counter as well. I wonder if there is a remnant of it that is triggering some logic I'm not aware of.


View solution in original post

12 REPLIES 12

Chuck Tomasi
Tera Patron

Yes, it is very possible for an extended table to use the numbering of a parent table. I just tried it out and it works fine.



Parent table gets TST0000001


Created a child table: TST0000002



and so on.


Hi Chuck and thank you - how is that done though? What do I have to set-up for Table A to use Table B's numbering? From what I tried, just shutting off the auto-numbering of Table A was not enough...


Turn on auto numbering on the parent (table B in your case, if I read this right.)



Turn off auto numbering for the child (table A in your case.)



Go to System Definition> Number Maintenance and ensure there is no record for table A to count. If there is, remove it.


Let me know how that goes.