how to connect 2 data source in relation one to one without errors

I want to add checkbox column to warehouse form that for using it later with external application.
I create new table called inventlocation_custom and set its primary column to inventlocationid and add another column from extend data type noyes (enum)

Then in invent location form I add another data source for inventlocation_custom then I choose in join datasource with inventlocation and link type (I tried all of them till I got inner join that display all check box status)
My problem is I can’t add new records and or if I change link type I can’t update check box
my problem description and images at comming link
as.a4egypt.com/Question.zip