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.

 

[Pat Hartman]

You said you are using a query. Does that mean you are using a form bound to a query since that is what you should be doing: For three tiers, you need three forms. A main form for the Projects table (please fix the name of the PK), a subform for the WorkOrders queyr, and a subsubform for the RFLog.

Just FYI, I would not use a two field PK for Workorders. I would create a unique index on the two fields but use an autonumber as the PK. Then change the RFLog to reference the autonumber and remove the two FKs it is currently using.

 

[isladogs]

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