OraFAQ Forum: Forms » trigger during fetching a record.

Home » Developer & Programmer » Forms » trigger during fetching a record.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

trigger during fetching a record. [message #600572]

Fri, 08 November 2013 06:11

nkumar0130
Messages: 55
Registered: August 2013
Location: Bangalore

Member

In form there are three block B1,B2,B3, all three B1,B2 and B3 are based on three different tables
B1 is master for B2 and B3 both.B2 and B3 are linked to B1 through account number.
B1 contain a column account number, so by querying a account number in B1 it will fetch all the record in B1,B2 and B3.
So my requirement is that, If i query an account number in B1 and that account number has no data in B2 but having a data in B3 then it will show a pop up message that no data found and will not display any data in any1(B1,B2,B3) of the block.

Can you please let me know which trigger i have to use for it and where we have to use.

Thanks

Report message to a moderator