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