Home » Developer & Programmer » Forms » Avoiding repeating values entry
Avoiding repeating values entry [message #323944] Fri, 30 May 2008 02:14 Go to next message
lokimisc
Messages: 88
Registered: February 2008
Member
Hi,

In a form there are few fields which I don't want to enter for every new record, this field should retain their previous values unless it is changed.
( say item1, item2....item20. Item1 to Item10 should retain the same values of previous record. while Item11 to Item20 should get clear for every new record).

If i use duplicate_record in when new record instance then it will retain all the values of previous record in all items.

Can anyone please help me to implement this ??


regards,
Lokesh


Re: Avoiding repeating values entry [message #323948 is a reply to message #323944] Fri, 30 May 2008 02:31 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Duplicate record and delete values of all items that should not be repeated, one by one.
Re: Avoiding repeating values entry [message #335336 is a reply to message #323944] Mon, 21 July 2008 20:48 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Or, in the 'when_new_record_instance' only populate the new fields that you want to contain the old information. This will stop the 'when_validate_item' triggers on the 'unwanted' fields from firing.

David
Previous Topic: Missing Status Bar - occasionally
Next Topic: Using PL/SQL library object in the sub Menu
Goto Forum:
  


Current Time: Fri Dec 09 15:36:14 CST 2016

Total time taken to generate the page: 0.16322 seconds