>Hi Erik,
>
>Can you be more specific as to where in the TasTrade sample I
>can find the example of generating the unique ID? I have looked
>in the methods of most of the .scx's and didn't find anything that
>looked like that. Thanks
>
>Regards,
>
>Paige

Look in the dbc at the stored procedures. There is function there called newid that accepts an alias and returns an incremented id. The trick is to put a call to this function in the default valur property of your primary key field.

newid('thisalias')

Or (if I remember correctly), just

newid()

and the current alias is looked up in the table.