Home » Developer & Programmer » Forms » Only one checkbox should be checked at a time
Only one checkbox should be checked at a time [message #190754] Fri, 01 September 2006 02:21 Go to next message
marlon_loyolite
Messages: 66
Registered: July 2006
Member
Hi Friends,

This is the scenario,

I have a Master and Detail relationship,in which in the master block I have check box for each associated record.

My requirement is whenever I check a new checkbox (record) in the Master block , the others should be unchecked.

Can anyone help me(Not with radio button).

Regards,
Marlon.
Re: Only one checkbox should be checked at a time [message #190798 is a reply to message #190754] Fri, 01 September 2006 05:26 Go to previous message
gacki
Messages: 33
Registered: May 2006
Location: Dueren, NRW, Germany
Member
Put the following code into the WHEN_CHECKBOX_CHANGED trigger of your checkbox item:
    	
....
v_save_rec_no := get_block_property('FABASE',CURRENT_RECORD);
first_record;
loop
if get_block_property('FABASE',CURRENT_RECORD) <> v_save_rec_no
   then
     copy(0,'FABASE.CHECK_BASE');
   end if;
   exit when :system.last_record = 'TRUE';
   next_record;
end loop;
first_record;
....

and replace FABASE with your block and CHECK_BASE with your checkbox item.

Gerald
Previous Topic: Diff between Post change and When validate Item
Next Topic: How to give Software demo
Goto Forum:
  


Current Time: Thu Dec 08 16:33:31 CST 2016

Total time taken to generate the page: 0.09959 seconds