Can't Update Form/Query based on Several Tables

[dancole42]

So I have a fairly complex database of software bugs, and three tables are giving me a huge problem:

t_Bug
t_TPID
t_BugAction

t_Bug is the main table of bugs, PK is bug_id.

t_TPID ("Third Party ID") is a table of all the multiple ways that our various clients refer to the particular issue. It relates back to bug_id (FK is just "bug"). Not every bug has a record in t_TPID, but some have many.

t_BugAction is a table of timestamped actions taken on a particular bug (reported, tested, fixed, etc.). It also relates back to bug_id (FK is also just "bug"). Excluding orphaned records, every bug has at least one record in Action, and some have many.

If I want to make a query that pulls all bugs that are "fixed," that's easy. I just do:

SELECT t_Bug.Bug_id, t_BugAction.BugActionQueue
FROM t_Bug INNER JOIN t_BugAction ON t_Bug.Bug_id = t_BugAction.Bug
WHERE (((t_BugAction.BugActionQueue)="fixed"));

Great! I can now edit all the fixed bugs.

Also, if I want to make a query that pulls all bugs that match a particular client reference, I just do:

SELECT t_Bug.Bug_id, t_TPID.TPID
FROM t_Bug INNER JOIN t_TPID ON t_Bug.Bug_id = t_TPID.Bug
WHERE (((t_TPID.TPID)="jerry's thing"));

Now I can edit all of "Jerry's things."

The issue comes if I want to view all of Jerry's fixed things:

SELECT t_Bug.Bug_id, t_TPID.TPID, t_BugAction.BugActionQueue
FROM (t_Bug INNER JOIN t_TPID ON t_Bug.Bug_id = t_TPID.Bug) INNER JOIN t_BugAction ON t_Bug.Bug_id = t_BugAction.Bug
WHERE (((t_TPID.TPID)="jerry's thing") AND ((t_BugAction.BugActionQueue)="fixed"));

It selects the records just fine, but the issue is that the recordset is not updateable! This is a huge problem, because being able to edit bugs in the various action queues filtered on third party info is key to this particular database.

What am I doing wrong?

Thanks!