OraFAQ Forum: Forms » problem with synchronization between multirecord block fields

Home » Developer & Programmer » Forms » problem with synchronization between multirecord block fields (forms 6i)

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

problem with synchronization between multirecord block fields [message #286541]

Sat, 08 December 2007 00:17

venkatadeekshi
Messages: 17
Registered: October 2007

Junior Member

Hi All,

I have a form with a multirecord block.In that block four field values are dependent on each other and all the fields have associated LOVs. Field2 LOV is dependent on field1 value, Field3 LOV is dependent on field2 value and Field4 LOV is dependent on field3 value.

All the LOVs have Validate from list property to YES.

Currently, When i update the field1 value and save it, it allows me save the record.

Infact it should prompt me to change the values of the field 2, field3 and then field4, as these values are dependent on the previous ones.

Is there any way when i update any of the fields and try to save it, it should popup the LOV of the other dependent field.

Thanks in advance

Report message to a moderator

Re: problem with synchronization between multirecord block fields [message #286602 is a reply to message #286541]

Sat, 08 December 2007 16:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You might save the "original" values of those 4 items in the PRE-RECORD trigger and compare them with item values during commit time. If these are different, fine. If not, go to the next item and open its list of values.

Report message to a moderator

Re: problem with synchronization between multirecord block fields [message #288888 is a reply to message #286602]

Wed, 19 December 2007 00:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Consider setting fields 2, 3, and 4 to null when the contents of field 1 are changed.

David

Report message to a moderator

Re: problem with synchronization between multirecord block fields [message #290206 is a reply to message #288888]

Thu, 27 December 2007 23:42

venkatadeekshi
Messages: 17
Registered: October 2007

Junior Member

Hi David,

I implemented your suggestion.

Thanks & Regards,

Deekshit

Report message to a moderator

Previous Topic:	Clearing those records of a multirecord if the checkbox associated with them is unchecked
Next Topic:	THE ATTACHED FILE DIDN'T WORK WITH ME !!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 01:17:28 CST 2025