Insert data into multiple tables

Hello,

I have a general question about inserting data.

I have the following tables:

CREATE TABLE customer (
	client_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	addr_id INT,
	account_type INT,
	how_hear INT,
	cc_type INT,
	cc_exp VARCHAR(5),
	cc_num VARCHAR(16),
	sign_up_date DATE
);

CREATE TABLE addresses (
	addr_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	fname VARCHAR(16),
	lname VARCHAR(16),
	company VARCHAR(72),
	addr1 VARCHAR(72),
	addr2 VARCHAR(48),
	city VARCHAR(32),
	state VARCHAR(3),
	zip VARCHAR(16),
	country VARCHAR(32),
	phone VARCHAR(18),
	fax VARCHAR(18),
	email VARCHAR(74)
);

I need to insert data into both of these tables at one time.  I want to have 
the "addr_id" field in the addresses tables to be included in the insert of 
data to the customer table.

My solution so far is to have 1 insert statement that inserts the 
appropriate data into the addresses table (creating a record), then have a 
select statement pull back the most recent (which is only milliseconds old) 
record from addresses and get the addr_id (it would probably be set to a 
variable) then when all other data is gathered for the customer insert the 
addr_id would be included in that insert.

This seems really difficult to do a simple insert and I was wondering if 
anyone knew if I could use something like a view that would allow me to 
insert into multiple tables with one statement?  I didn't see anything 
reguarding views in the documentation.

Any ideas how to solve this?

Thanks,
Kevin
kevsurf4@hotmail.com
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com