Fix for duplicate number from multiple table

[Pat Surtan]

I am using 3 tables. 1 parent table and 2 child tables. The 2 child tables are inheriting the same numbering format as the parent so when a ticket is created from child table, that same ticket shows in the parent table.If you're viewing the list from the parent table, all the tickets are there. Also, if you are view the list from each child table, only the tickets that were opened for that table is displayed.

The issue I am having now is, there are duplicate numbers in the table. A ticket from the child table has the same ticket created from parent table even though both tickets are different.

Can someone provide a fix for my issue?

[Laszlo Balla]

1. Are your number fields on the child tables inherited from the task table, i.e. is it the "default" number field? If not and custom, are they at last inherited from the parent table?
2. Did you turn on auto-numbering for the child tables? This should not be necessary as long as they extend the parent table and the parent table has the auto-numbering sequence defined.

[Pat Surtan]

Hello Laszlo, 

My parent table is extended from Task, and my 2 child tables are extended from my parent table. Both my child tables are not using auto numbering. 

[BharathChintala]

That is expected behaviour as your child records having parent number 

when you see in parent table parent number will duplicate as it contains multiple child

[Pat Surtan]

How do I ensure that the child records submitted use a number that doesn’t already exist in parent table?