Hi,

Some of my tables have unique id fields like Order Number, or Reference Number, etc. 

What would be the best way to handle the creation and maintenance of those type of fields? 

Is there any facility in SF for these fields?

Thanks!

Edhy Rijo

Hi Trent,

Thanks a again for the sample code, much appreciated, even though in VFP I was already spoiled since this kind of feature is already part of the framework

I will review your suggestions an I'm sure I will come up with a solution out of it.  In my experience with VFP I have seen many of these implementations and was hopping to find something already available in SF to use, instead of coding it myself, which also improve my learning curve of the tools.

Edhy Rijo

I must misunderstand what you are trying to do then because to my knowledge, VFP didn't do any of this for you.  We had to create this very same type of logic on our VFP apps.  They had auto-incrementing fields (VFP8 and later) but that was it.  SQL also has auto-incrementing fields, which is another choice.  Let me know if I am missing something

Hi Trent,

You are right, it was not part of VFP, but all VFP 3rd party frameworks including Visual ProMatrix the one I still use for my VFP projects have this kind of functionality for all type of fields (see picture attached).

This kind of feature could be added to the Business Object Mapper along with other information related to the field like Input Mask, Format, Tooltip, Error Message, etc.

Edhy Rijo

We're looking into some of this functionality for the next version where we will allow meta-data about the field to be specified at the business object level.  But right now, that sort of functionality requires major plumbing and is more than just a quick patch, so I don't think it will make it into this major version.