Home » Developer & Programmer » Forms » Need Help
Need Help [message #113201] Thu, 31 March 2005 10:09 Go to next message
Sabeen
Messages: 25
Registered: March 2005
Location: Pakistan
Junior Member
Hi, i need help. infact i have a table with two fields. department no and name.
i created two blocks one is dept with both fileds and second is dept1 just with one department name field.
now i rais when new form instance trigger with code
go_block('dept1')
execute_query.
means i fetch all the dept names in dept1 block when form starts.
i want that whenever i do any change (insert new record,update,delete record) in dept table by using dept block then deprtnames should be update in dept1 block automatically.
how can i achieve this.
kindly help me.
i have tried lot of times but failed.
thanx for help.
regards
s sabeen
Re: Need Help [message #113365 is a reply to message #113201] Fri, 01 April 2005 11:41 Go to previous message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

You can use the trigger When-Validate-Item/Record and update/Delete the dept1 column in the trigger code using the values you have given in the original form.
Previous Topic: master detail form problem
Next Topic: Web enabling Oracle applications
Goto Forum:
  


Current Time: Thu Sep 19 18:02:14 CDT 2024