Using Data Bridge can an update form be created that shows existing values? IE a form to update an existing record from a database

When I create a form with data bridge and then click on the form fields I don't get the option to bind the value to a recordset. The net result is that I can't use the tool to create a form that would allow a user to update an existing record.

If you use the Data Assist wizard and have it create a Results page and an update page, it will be configured for you.

Originally Said By: Jason Byrnes

  If you use the Data Assist wizard and have it create a Results page and an update page, it will be configured for you.  

Problem is that the form was laid out carefully as a custom form, and I was under the impression that I would be able to make this custom layout work for update too, but apparently I was wrong. Using the custom form interface is very manual and labor intensive, and manually binding everything is even worse. I would have thought that the tool should be equally adept at building an update as an insert since there are very similar. I'm quite disappointed by the slow frustrating interface. If I wanted plain vanilla I would use a rad tool on a Microsoft stack and be done in 1/10 of the time. I thought that these tools would let me maintain a greater degree of design control. I would like to strongly suggest that you add an option that would basically clone an update form from an insert form, or better yet let a user select either insert or update for any custom form. All the fields have to be mapped for the insert, so using that information to map to an update should not be overly difficult it seems. (I realize it isn't a tiny job, but it would improve the usability of the tool an order of magnitude!)

Ok, You did not include that information in the original post. It is certainly possible to use the update on a manually created form, however, it requires that you have an understanding of how the update process works.


with an update page, you would always have a results page so that you can select the record you wish to update.

The results page will pass the records ID as a querystring variable, for example:
update.php?id=12

on the update page, you need to create the recordset and set it to filter the ID column using the ID recordset.

you can then bind the initial value for the form elements to the columns from the recordset.