+ Start a Discussion
UADUAD 

Continuous Auto-Number

Hi,

 

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.

 

Example:

 

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?

 

 

edit:

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