Select value from combo boxes frm multi tables and store in diff t

  • Thread starter Thread starter ScottMSP
  • Start date Start date
S

ScottMSP

Hello,

I have a database with three tables:
tJobCode – primary key is JobCode
tSurveyData – primary key is no primary key defined
tSurveyMatches – primary key is PrimaryJobCode

On a form, I need to be able to select from a drop down box a job code from
tJobCode (i.e. 00964) and then match survey data from tSurveyData (i.e.,
SurveyID (ID of a particular survey, SurveyJobNumber (number of the job in
the specific survey), and the SurveyBreakout (Region – Other Locations).
With these three pieces of information from tSurveyData, it identifies a
specific row of data that contains HourlyRate.

I need to be able to then store the selections of JobCode, SurveyID,
SurveyJobNumber, and SurveyBreakout in a different table titled
tSurveyMatches. I think that once this information is in that table I will
be able to then pull the data that corresponds to that particular match.

Hopefully this makes sense.

Thanks in advance.

-Scott
 
Use a form/subform from tJobCode/tSurveyMatches and have a combo box in the
subform to select the SurveyID.
 
Back
Top