Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> database design

database design

From: auddog <will_k_at_hotmail.com>
Date: Tue, 7 May 2002 11:16:18 -0500
Message-ID: <udfvhq9m0pj718@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
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US