You may go through every record in that block and add some business logic such as :
if not checked then
change record status as non insert status ( :system.record_status )
But as implementation experience , we don't suggest using that way
You may create a temp block (non base) , and just insert those records if checked
Commit_Form built-in function commits all the available data base fields. So you have to use separate insert into statement to complete your task.
for i in 1 .. 4
if :chk_box='Y' then
Insert into <table_name> values(field1,field2,....);
Thanx to reply I have already done this but it is effective when I have a checkbox field in same database table.But I have the check box items not in same data block.It comes from another view.
Its not necessary I considered the ceck_box as a non database item only on my post.
If you are using non db field for Check box means you can opt it in the same datablock itself.
On the other hand if you want to make the check box in a separate datablock means you have to provide relation details to the parent datablock..,