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

Hi - I went in to where you said, found the record, and deleted it. It still doesn't seem to be working, Table A is still creating it's own numbers upon record creation.



I even went into the Form Layout of the form of Table A and switched the field from "Number" to "Parent.Number" - now it comes up as blank.


You may be mixing up table extensions with reference fields. The field parent.Number is a referenced field from a related record (the parent record.) Table extensions are a different concept (incidents, problems, changes, etc are all extended from task.)



find_real_file.png



Table Extension - ServiceNow Wiki


Thank you - I will look into that - much appreciated!


Hi Chuck,



So, it looks like Table B's (the parent table) number field is from the Task Table (as you suggested above), when I look at the dictionary info for the number field for Table B it says this



        Dictionary Info: TableB.number


                                      Table task


                              Element number


                                        Type string



So it sound like this is what you suggested above. So is there a way I can use table extensions to make Table A have the same thing? Maybe something that looks like this?



        Dictionary Info: TableA.number


                                      Table task


                              Element number


                                        Type string


Update: I was able to reach this point:



        Dictionary Info: TableA.number


                                      Table task


                              Element number


                                        Type string



but the number it still comes up is its own count, not a continuation of the running number of Table B (which also uses the task table). If I were to go to Table B and create a record, the number field would read something like "REC0003456". I would like it where when I create a new record in Table A, the number field would read "REC0003457" instead of "1180".