Re: Database Structure Question ... Serious Help Only Pls

In article <1156789688.246004.131370@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
DrewKull@xxxxxxxxx says...
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???


CREATE TABLE ProblemCodes
(problem_code CHAR (2) NOT NULL PRIMARY KEY,
code_name VARCHAR (250) NOT NULL);

CREATE TABLE Sources
(source_name VARCHAR (20) NOT NULL PRIMARY KEY);

CREATE TABLE Problems
(problem_id AUTOINCREMENT (1,1) NOT NULL PRIMARY KEY,
problem_code CHAR (2) NOT NULL
REFERENCES ProblemCodes (problem_code),
problem_text MEMO NOT NULL,
source_name VARCHAR (20) NOT NULL
REFERENCES Sources (source_name));

.

Relevant Pages

  • Re: Lookup Evils
    ... StationID (primary key; ... BoreholeWell (Borehole or well? ... You mention survey coordinates. ... StationID ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Connecting different numbers of fields to one field
    ... Clearly each survey ... QuestionID (primary key) ... tblQuestion for all questions in all surveys, ... tblComment for all responses and comments for all questions in all surveys. ...
    (microsoft.public.access.gettingstarted)
  • Re: How do I update a cursor after adding a record to the underlying table? Or vice versa?
    ... > insert if I happened to pick the wrong master question. ... > the second survey. ... > than that of record id to the primary key field. ... > the grid by inserting into the view via the INSERT - SQL command. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Primary Keys
    ... Identity columns make for excellent clustered unique indexes. ... favorite is the effect this has on cache. ... do not use the Identity column as the primary key. ... > feedback on keys and indexes are welcomed. ...
    (microsoft.public.sqlserver.server)
  • Database Structure Question ... Serious Help Only Pls
    ... so i have a database im building to track user feedback. ... survey table. ...
    (comp.databases.ms-access)
Loading