Thanks June, that is what I am trying to do.
Still, the "where" condition is on analysis.code and AnalysisType.TypeDescr, the text field (of course I do not use the PKs as inputs)
This is where I got stuck. This query will get the FK_analysis:
Code:
SELECT Analysis.PK_AnalysisFROM Analysis
WHERE code=[Analysis code?];
while this one will get all the FK_tests according to an analysis type:
Code:
SELECT TypeTest.FK_test
FROM AnalysisType INNER JOIN TypeTest ON AnalysisType.PK_analysisType = TypeTest.FK_Type
WHERE AnalysisType.TypeDescr=[Analysis type?]
I really do not know how to put both into a Insert query