trying to code a command button to do the following :

1. add a new record to the table the form is based off of
2. drop the new project number into the 3 or 4 other tables that use it

can anyone think of a decent way to accomplish this considering i only have a rudimentary knowledge of VB?

Brandon