nuBuilder Forum

All subforms are unrelated to each other - there is only one common field with the date. All other forms work correctly, only the co_put table has problems. Is it possible to ignore the other forms?

I uploaded cogp.sql to another database.
Based on the loaded table cogp_tab, I created the form tab_cogp. Changed the fio field property - - no check for empty value.

I didn't touch the other forms. The problem form c_p behaves similarly to the problem described earlier, i.e. its behavior does not depend on other forms!!!!
It took 5 minutes...

I changed the SQL of cogp_p from

to
and saving seems to work now.

Kevin, thanks for spending your time on the weekend, but the line

JOIN cogp_tab ON co_put.p_tab = cogp_tab.tab_id

means that the co_put table receives the date from another table - cogp_tab. Also, 4 other subforms on this form receive the same date in the same way, and they work correctly.
There must be another reason for this behavior

Kevin, you won't believe this, but the problem was in the SELECT field.

I took the code from the help and assigned a list like this:
0|Loaded|1|Empty

After several days of torment, I simply brought the list to this form:
1|Loaded|2|Empty

You can’t imagine what my surprise was - everything worked correctly right away!!!
Of course, I will continue to watch, because I can’t believe such a glitch.
Thank you for participating !!!