| Only one checkbox should be checked at a time [message #190754] |
Fri, 01 September 2006 02:21  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
