Data entry Query

[Angel G]

Hi I am trying to have a query open up (which later I will use as a form) so
that I can do data entry, but because I am joining a table it does not allow
me to add records (One to many relationship). The PartNumberTests_tbl table
contains all tests pertaining to a specific part number. In the
TestResults_tbl table I want to be able to add the results of each test that
applies to the queried partnumber. I do not need to write anything to the
PartNumberTests_tbl table since it is updated by the use of a form (adding
or modifying test parameters for a specific part number)
Can this be done? should I be using a different approach?
Here is my query.

SELECT PartNumberTests_tbl.PartNumberID, TestResults_tbl.PartNumberID,
TestResults_tbl.TestID, TestResults_tbl.Min, TestResults_tbl.Max,
TestResults_tbl.Result, TestResults_tbl.PassFailResult
FROM PartNumberTests_tbl LEFT JOIN TestResults_tbl ON
PartNumberTests_tbl.PartNumberID = TestResults_tbl.PartNumberID
WHERE (((PartNumberTests_tbl.PartNumberID)=1));

 

[Guest]

I would suggest a form/subform with Master/Child links using PartNumberID.

But you will not get many records with WHERE
(((PartNumberTests_tbl.PartNumberID)=1))