+ Start a Discussion

Continuous Auto-Number



I created a custom object who has a master-details relationship,indeed, this custom object will only be used as a child of my opportunity.

I needed to set an auto-number for this object, by the way it's pretty easy , but  the issue is that i want to make this number continuous for his master opportunity.




The  auto-number is set as : INV-{DD}{MM}{YYYY}-{000000}

If i'll create a record on my opportunity called 'Opportunity#1' the number will be INV-021012-001

Afterwork i'll create a second record on an other opportunity called 'Opportunity#2' the number will be INV-021012-002


Do you any way to make the auto number continuous?




I imagine a way with and hidden field and workflow rules but it's a bit mess isn't it?