Database Structure Question ... Serious Help Only Pls

Giganews Newsgroups
Subject: Database Structure Question ... Serious Help Only Pls
Posted by:  DrewKu…@gmail.com
Date: 28 Aug 2006

Ok ... so i have a database im building to track user feedback.  The
problem im running into is we need to track "Problems" detected in the
feedback, but we have multiple inputs for feedback.  So right now, we
get feedback from Surveys and Email.  The problem im running into is a
neeeed to link these two input to a common "Input ID" in order to
easily track a "Problem"  (each "Problem" will have an "Input ID"
showing the source of the Problem whether it was from a survey or
email).  But my problem comes up with large imports that i do into the
survey table.  So when i add a bunch of data (by import or copy/paste)
into the table, the Input ID is not updated because that MUST be kept
in a separate table in order to link both inputs.  Does that make
sense?  So how do i do this?!?!  Here's a "diagram" of my tables:

Survey:
- Input ID (FK from Input)
- Date, etc.

Email
- Input ID (FK from Input)
- Date, etc.

Input
- Input ID (PK,AutoNumber)
- Type

Problem
- Input ID (FK from Input)

So the problem is when i add data to Survey or email, I dont want to
manual add data to Input then go back to Survey and input the next
AutoNumber generated ...

Does this make sense?  Any ideas???

Replies