>I built ane stored procedure to assign the primary key to the employes's table.
>
>How can I invoke the stored procedure in the moment to insert the record ??
Put the procedre call in the primary key's default value property in the table designer.
>
>Can I invoke the stored procedure from a command button ??
Yes. As long as the Database is open and current, you can just call the function with
lcVal = Myfunction()
Erik Moore
Clientelligence