Hi to all
the requirment the we have already master detail form.example emp details based on the dept number.in the form just only displays three coloumns per record wise(emp details).
actually my requrment is place the check box each record and place a one button in the form.once check the particular record and click on the button open the another form
it's displays that particular record entire emp details.any one help me...........
Edited by: 994418 on 3 Apr, 2013 1:50 AM
994418 wrote:Hi, s.
thanks for giving reply.
yes emp block is tabular ,in this i display 10 records at a time.my client want's to add a check box each record and place a only one button in the form. placed on the cursor the particular record and check the check box and finally click on the button open the another form,it;s displays only the particular record details.thisi s exact requirment
my client want's to add a check box each record and place a only one button in the form. placed on the cursor the particular record and check the check box and finally click on the button open the another formNow this may be what your client wants, but it is in fact incorrect. With a check box, you can check any number of boxes in the tabular form. This is standard behaviour of check boxes. You cannot limit it to only one box that is checked (without extra programming). What are you going to do if the user checks two boxes?
WHEN BUTTON_PRESSED IF 'yes' = :block_form1.check_box THEN :global.check := :block_form1.RECORD_ID open('FORM2') END IF;
when new_form_instance: set_block_property('detail',ONETIME_WHERE,'RECORD_ID='||:global.check); go_block('detail'); execute_query;