database design

i have a newbie question that i have tried to work out but don't understand how to make it work. here goes:

table1 - project

id
name
address

table2 - construction

id
name

table3 - project-construction
id
project_id
contsruction_id

the first table is project for project name as well as a job id, which is auto_incr. when i create a new job. the second table is construction type - ie - metal, wood, etc. the third table is combination table of the previous two tables. my question is how do i populate the last table when i'm creating a new job, since i don't know the id until after auto_incr. has given it a number. hopefully this make sense. thanks for the help in advance

will Received on Tue May 07 2002 - 11:16:18 CDT