>>
>>1. open your project
>>2. look in your database (data tab)
>>3. try a few times and see how it works.
>>
>>once you add the stored procedure and call it in the default value function for that field in your table, the column will be generated automatically when you add a record (ctrl y or append blank)
>
>thanks Dave... In the Database Desinger and under the menu option Database,
>there is an option called EDIT STORE PROCEDURES. Do I put my code there,
>because I did not see a place to ADD a NEW STORED PROCEDURE?

try it and see.