>>>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
Timothy Bryan