Hi,

I have setup an IP form such that I have a drop down menu of names
populated from a secondary datasource (and bound to main:queryFields).

I then have four text boxes bound to main:dataFields which are
automagically filled in based upon what is selected in the drop down
menu (using an onAfterChange event handler).

What I am trying to do is allow the user to select from the drop down
list and modify the information to submit back to the SQL DB.  The
problem is the update never happens but a new row is inserted in the
table.

When I use the default 'New Record' and 'Run Query' sections it works
fine...but this setup is a really poor UI.

Does anyone know how I can accomplish the update?? Will I have to code
the update statement myself?
Let me know if you need more info in order to help me!!

TIA!