I have tables as follows:
ClientT
-------------
ClientID (PK)
ClientName
IsClientActive

ClientNumberT
--------------
ClientNumberID (PK)
ClientNumber

ProjectT
ProjectID (PK)
ProjectName
InternalClient
ProjectTypeID (FK) to ProjectTypeT

EmployeeT
--------------
EmployeeID
EmployeeFirstName
EmployeeLastName
UserName
Password
EmployeeTypeID (FK) to EmployeeTypeT
SecurityLevelID (FK) to SecurityLevelT
IsEmployeeActive

ClientxEmployeeT
------------------
ClientID (CPK)
EmployeeID(CPK)

ClientxProject
-----------------
ClientID (CPK)
ProjectID (CPK)

ClientxClientNumberID
---------------------
ClientID (CPK)
ClientNumberID(CPK)

* Each client can have many projects.

* Each project will have different start and end dates (not built yet).

* Each project will have multiple employees in varying roles. There could be 1 project manager or 2, etc.

* Each client can have more than one client number per project.

I have created the relationships.

When I build a form, I have tried to set the Record Source = custom query that includes ClientName, ClientNumber, ProjectName, EmployeeFullName (concatenated) as PMName, EmployeeFullName (Concatenated) as BackupPMName, employeeID, EmployeeType, and ProjectType.

Every time I run the query, the query works just fine.

However, when I try to update a field in the query, I get the error message of "recordset is not updateable".

If I leave off several tables, I can update the field when I run the query.

How do I create a form with all of these field from multiple tables that I can filter AND edit?

---

Reply from Alex Hedley:

You could use subforms on a main form.