>>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.