Unable to modify data - Form referencing 3 tables

[rjunk]

Hey folks.
I'm an excel guy, but from time to time play with Access.
I have three tables (Employees/Computers/Printers) which together will track which computers and printers have been issued to which employees by serial numbers and employee numbers.
The relationships I have built essentially just join the employee IDs in both the computers table and printers table, with the list of employee IDs in the Employee table
My form shows an employee ID and the equipment model numbers and serial numbers for the computer and printer assigned to that employee.
...And it works too. I can see every employee record.
The problem is that I cannot modify any of the data through the Form.
I have checked all of the properties and done anything I can find in the Help feature, but am at my wits end.
Anybody have any Ideas?????

 

[rjunk]

The database has changed somewhat now, but the problem remains the same.
When I go to the SQL, here is what I see:
SELECT Employees.[B Number], Employees.[Full Name], Employees.Position, Employees.Branch, Employees.Phone, Computers.Type AS Computers_Type, Computers.Model AS Computers_Model, Computers.[SERIAL NUMBER] AS [Computers_SERIAL NUMBER], Computers.Notes AS Computers_Notes, [2ndComputers].Type AS 2ndComputers_Type, [2ndComputers].Model AS 2ndComputers_Model, [2ndComputers].[SERIAL NUMBER] AS [2ndComputers_SERIAL NUMBER], [2ndComputers].Notes AS 2ndComputers_Notes, [Local Printers].MODEL AS [Local Printers_MODEL], [Local Printers].[SERIAL NUMBER] AS [Local Printers_SERIAL NUMBER], [Local Printers].Notes AS [Local Printers_Notes]
FROM ((Employees LEFT JOIN Computers ON Employees.[B Number] = Computers.[B Number]) LEFT JOIN 2ndComputers ON Employees.[B Number] = [2ndComputers].[B Number]) LEFT JOIN [Local Printers] ON Employees.[B Number] = [Local Printers].[B Number];

 

[Norie]

Can you outline what tables you have?

Do you have the following?

Employees
Computers
2ndComputers
Local Printers

 

[rjunk]

Yes.
Those are the tables I have.

 

[Norie]

Ray

When you open the query you posted in datasheet view can you change/update records?

If you can't it's probably because somewhere the relationships between tables haven't been set up correctly.

What is B Number?

What are the primary keys of each table?

Are there any foreign keys in any tables?

 

[rjunk]

No, I cannot edit the query in datashee view.
B Number is employee number
Each table has an auto number primary key.
I have not intentionally assigned any foreign keys, as I do not yet really understand what they do.