database design
From: auddog <will_k_at_hotmail.com>
Date: Tue, 7 May 2002 11:16:18 -0500
Message-ID: <udfvhq9m0pj718_at_corp.supernews.com>
i have a newbie question that i have tried to work out but don't understand how to make it work. here goes:
Date: Tue, 7 May 2002 11:16:18 -0500
Message-ID: <udfvhq9m0pj718_at_corp.supernews.com>
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
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
id
project_id
contsruction_id
will Received on Tue May 07 2002 - 18:16:18 CEST