Very Urgent , please help me! [message #81061] |
Thu, 02 January 2003 02:44 |
maha
Messages: 11 Registered: November 2000
|
Junior Member |
|
|
hi there,
i have two blocks in a form(two tables)and i have an insert button ok?
when i enter information in one block i can insert, but i want to insert only when the two blocks items are entered totally, how can i do it?!!
|
|
|
|
Re: Very Urgent , please help me! [message #81068 is a reply to message #81061] |
Thu, 02 January 2003 10:25 |
Julie
Messages: 98 Registered: February 2002
|
Member |
|
|
I think you are going to need to code logic on the pre-insert trigger to check for your required fields and raise a trigger error if they are not all there.
Making the fields all required, will only complain about the current block they are positioned on when they click save. It won't check the other block. So write code to check both, write it as a procedure and call it from the pre-insert trigger of both blocks.
|
|
|