ACCESS RELATIONSHIP AND QUERY CAN'T EDIT

[aj.ajuzzz]

I have set relationship like this i can't edit in query shows error as like this

when editing WO or Project_ID from table WorkOrders error like this

When editing ID from table Projects error shows this

I am beginner to access, if it is a blunder.. please guide me to solve this one. i am trying to build a access database to myself for my work from youtube videos.

 

[arnelgp]

right click the lines between projects table and workorders table.
Edit the relation. on "Join Type", choose "Include ALL records from Projects...".

Right click the Line between workorders table and RFILog table.
same as above, but this time choose "Include All records from workorders table"
Do the same on the other line.

this will make a Left join.

 

[aj.ajuzzz]

right click the lines between projects table and workorders table.
Edit the relation. on "Join Type", choose "Include ALL records from Projects...".

Right click the Line between workorders table and RFILog table.
same as above, but this time choose "Include All records from workorders table"
Do the same on the other line.

this will make a Left join.

Thanks for the reply it didnt work. shows error as like this

 

[arnelgp]

Delete the relationship and re-create it.
if you are Editing Project_ID, you need to Cascade Update to the two tables.

 

[gemma-the-husky]

It sounds like you are trying to write a record into the "log" table for a record that doesn't exist in the workorders table.

 

[isladogs]

You might find these articles useful:
Relationships & Referential Integrity - Mendip Data Systems
Query Join Types - Mendip Data Systems