Update Query Key Violation

[wtrimble]

I have two tables that are connected in a query. They both have a primary key as "ProjectID" and have a referential integrity with each other (Update). The first table (tblmaster) has all of the ProjectIDs (1000) where as the second table (tbltwo) only has about 5 records.

I combined them in a query with the relationship that all of tblmaster records will be shown and only tbltwo records that match will be shown. Now I'm trying to do an update query with a linked table I have ( which is an updated version of the query) and it is telling me I have 995 key violations and it won't let me Update. I believe this is because thre are no record of the 995 ProjectIDs in tbltwo so it can't update.

Is this true and is there a way around it or do I need to do two seperate Update Queries.

Thanks for your help.

 

[wtrimble]

Anybody have any suggestions?

 

[SOS]

It is a bit confusing to me. I can't understand what it is you are storing in the other table and why. So, why are you linking the two tables and trying to store information in a third?

 

[wtrimble]

I have one master table with information about a unique ProjectID. There's another table that has supplemental (sp) information about the ProjectID (ProjectID's come from the master table), but only for a couple ProjectID's, not all. I created a query to combine the two tables for my co-worker to edit/update in excel, so all information of one ProjectID is on a line ( including supplemental info found on the second table).
The file excel file that my co-worker is updating is linked to the database. I want to then Update the query (master ftable and supplemental table joined) to the updated information.

Does this make more sense?