>>>>Hi,
>>>>
>>>>how do I generate consecutive numbers (for use as a customer number for example)? Is there anything in the framework that achieves this? I found reference to a function that autoincrements values, but it appears to b eonly on Primary Keys, this field is a candidate key.
>>>
>>>Have you considered using 2 columns? One would be an identify column that is your PK on the table. That value could be stored to the user-modifiable customer code if the user doesn't enter a code. That way you can do all your linking to related tables on the identity column and use the user-modifiable column to display a custom code, if desired.
>>
>>Thanks for the idea, but I don't think it will work because I am not using integers as my primary keys, but Guids.
>
>Frank, if the user doesn't choose to enter or use a customer number do you even need one? Can it just be left empty?
>Tim

Yes, I need one in order to identify different people with the same name.