S
ScottMSP
Hello,
I am struggling with table design and what primary keys to set up for
multiple tables that I need to link together and ultimately be able to edit
through a query/form.
tJobCode:
JobCode (unique field)
JobTitle
Grade
tPrimaryJobCodes
PrimaryJobCode
JobCode (unique field)
tSurveyMatches
PrimaryJobCode
SurveyID
SurveyJobNumber
Breakout
(I have tried composite primary key for SurveyID, SurveyJobNumber, Breakout)
tSurveyData
SurveyID
SurveyJobNumber
Breakout
(I have tried composite primary key for SurveyID, SurveyJobNumber, Breakout)
I need these four tables to interact with each other so that when I bring
them into a query or a form, that any of the fields can be edited. I have
had some success with the primary keys if I use two of the tables, but I know
I am not setting up the design correctly with the correct primary key(s) that
will allow me to edit this data when it is all on one query or form.
Thanks in advance.
-Scott
I am struggling with table design and what primary keys to set up for
multiple tables that I need to link together and ultimately be able to edit
through a query/form.
tJobCode:
JobCode (unique field)
JobTitle
Grade
tPrimaryJobCodes
PrimaryJobCode
JobCode (unique field)
tSurveyMatches
PrimaryJobCode
SurveyID
SurveyJobNumber
Breakout
(I have tried composite primary key for SurveyID, SurveyJobNumber, Breakout)
tSurveyData
SurveyID
SurveyJobNumber
Breakout
(I have tried composite primary key for SurveyID, SurveyJobNumber, Breakout)
I need these four tables to interact with each other so that when I bring
them into a query or a form, that any of the fields can be edited. I have
had some success with the primary keys if I use two of the tables, but I know
I am not setting up the design correctly with the correct primary key(s) that
will allow me to edit this data when it is all on one query or form.
Thanks in advance.
-Scott