I create 2 tables with reference between them. But when I save the data, key column does not stored in table

Here are my 2 tables. The Ref Key is PL_ID. REF_ROWS(“PL_Detail”, “PL_ID”)

When I insert the data in PL_Detail and save. The detail can be seen on the screen.

But after a few seconds, it just disappeared.

so I check the data in Google SpreadSheet

4

The reason is the Ref Key has not been saved.

Here is the setting of Ref:

Anyone know why?

What is going to happen if you change the PL_Detail filed to EDITABLE. Currently set as Not editable, which could be a reason.

5 Likes

Thank you very much. Change to “editable” solve the problem.

2 Likes