Subform Query Not updatable

[Denise Jackson via AccessMonster.com]

I have a subform on my main form. This subform should update
tblVerificationByJO, but it's not letting me update.

My qoal is from the data entry main form, click the company name from the
drop-down which will populate the subform with a list of packages specific to
that company. Then click yes/no if the package is complete. The cust
package table tblVerification2 just lists the packages needed and looks like
this:


1 ssn
1 employment
1 education
2 ssn
2 soc security
2 criminaal

The table tblVerificationByJO is what I am trying to update and will look
like this:
id cust pack JO#
1 ssn 123
1 employment 123
1 education 123
1 ssn 456
1 employment 456
1 education 456
There can be one company with many JO#'s

Here's my sql:

SELECT tblVerification2.CustPkg, tblVerification2.Companyid,
tblVerificationByJO.[Recd /Completed?], tblVerificationByJO.Date,
tblVerificationByJO.[JO#], tblVerificationByJO.SSN
FROM (tblVerification2 INNER JOIN tblJOProfile ON tblVerification2.Companyid
= tblJOProfile.Companyid) INNER JOIN tblVerificationByJO ON tblJOProfile.
Companyid = tblVerificationByJO.Companyid
WHERE (((tblJOProfile.Companyid)=[Forms]![frmDataEntry]![txtCompanyid]));

Does anyone help me sort this out??

Thanks,
Denise

 

[Denise Jackson via AccessMonster.com]

I’m trying to create an updatable query.

I have a main table with the primary key as the JO# and the companyid indexed
w/ duplicates okay. I have another table with companyid, JO#, date and ssn.
In this table the companyid is indexed w.duplicates okay and JO# indexed
w/duplicates okay.

I hope I’m explaining this correctly. I need the 2nd table to list many
duplicate companyid’s with many duplicate JO# records. This 2nd table will
be used on my updatable subform to list all the record items for a single JO.


The main table will have many(same) companyid’s but only One unique JO#
records. It’s the 2nd table that will have the many events for that JO#.

I think it’s how I’m setting up my keys, but I’ve tried different ways.

Please help.

Thanks,
Denise