Home » Developer & Programmer » Forms » Non-database column in form populates wrong field (Forms 6i, Database 8i)
Non-database column in form populates wrong field [message #391114] Wed, 11 March 2009 01:42 Go to next message
Derek N
Messages: 80
Registered: September 2002
Member
I have a multi row form based on a database table. One of the fields in the multi row form is a non database field. This field is populated by selecting an item from a list of values.

When I go into the form and press the lov button (eg. on row 10) and select an item, it populates the non database field but puts the value in row 1 of the form. If I go to row 15 and select an item from the lov it again puts the value into row 1.

However, when I click my mouse on one of the database fields on row 10 and then click the lov button, it puts the value selected into row 10.

There seems to be a problem identifying which row to put the value into when I do not click on any of the database fields first.

How do I overcome this as users are not prepared to first click on a database item and then press the lov button.

Thanks
Re: Non-database column in form populates wrong field [message #391130 is a reply to message #391114] Wed, 11 March 2009 03:28 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
LoV button probably isn't "Mouse navigable" - open this item's property palette and enable it.
Re: Non-database column in form populates wrong field [message #391149 is a reply to message #391130] Wed, 11 March 2009 04:08 Go to previous message
Derek N
Messages: 80
Registered: September 2002
Member
Made LOV "mouse navigable", now works fine.

Thanks Littlefoot.
Previous Topic: Message to indicate password expired
Next Topic: Restrict SQL use
Goto Forum:
  


Current Time: Thu Feb 06 14:33:30 CST 2025