Two serial numbers - one "basic" and another, more serious one...

[Anders Thorssell]

Hi all!

I'm setting up a database that involves building projects - a lot of these will never be sold and only end up as quotes, others will likely be sold and therefore has to "go live": what I need is a basic serial number, and then a "real" serial number that will be assigned only to the building projects that were sold...

The ideal way of doing it would be when the user changes a value in a drop down menu from, say "quote" to "ongoing". It'd be even nicer if it would involve a conditional custom dialog, so the user actually had to make a choice before assigning a new "real" serial number...

Any ideas or suggestions highly appreciated