Updating Multiple Tables

[eluser]Konvurt[/eluser]
Aleazus,

Thanks for the reply. I think I may have confused you in the post.

Basically I have three tables which share information. Grad_Applicant, Master_People, and Dept_People.

I am trying to create a function that will be called once to create a new dept_people entry. However, the function needs to do three distinct things.

1. Create an entry in the Master_people table (mp_id, mp_status, mp_role)
2. Create an dept_people entry which uses the mp_id previously created

I hope that is a little clearer.

Thanks