[Solved] Check in Check Box continues to next record in sub form

[Dalke55]

I have added a BOOLEAN field to a sub form and attached a CHECK Box for that field. My issue is when I click the box for the check option and move on to the next record in the sub form the box in the next record already has a check in it. How would I set the check box to clear on the form after going to next record. The Table fields are correct for the last record entered.

Attached image of Check Box properties General & Data tab

Thank You!

[UnklDonald418]

Open your table in the Edit mode and select the field TNT-BLU X
Make sure Default value is set to No
Example attached

Screenshot_20220822.png (15.39 KiB) Viewed 11937 times

[Dalke55]

Thank you, as soon as I get DBSchema to import my database schema I will make that change as the current setting is <none>. I cannot directly modify my HSQLDB ver2.3.2 with the editor.
Im currently waiting on DBSchema support so my result may be in a day or two.

[UnklDonald418]

You should be able to make the needed change at menu selection Tools>SQL by executing a command of the form

Code: Select all

ALTER TABLE "YourTableName" ALTER COLUMN "YourColumnName" SET DEFAULT 'SomeValue';

In your case substitute "TNT-BLU X" for "YourColumnName" and FALSE for 'SomeValue'

Tools>SQL bypasses Base and works directly with the back-end engine, in your case HSQL 2.3.2
To inform Base of the change(s) select TABLES from the main Base window
Then from the menu select View>Refresh tables

[Dalke55]

Thank You! Before I saw this last post I had an issue with BASE EDITOR, FORM NAVIGATOR and looked up a link that said to reset the user profile which I did, and fixed Form Navigator. I also found the CHECK BOX functioned properly and cleared when going to next record.
Thanks again