Sorm for updating multiple database records
In my example, I chose the results page so I can see the records that have been updated. Next, click on the Bindings tab to bind the database columns to the form fields. Select each database column in the Column list and if necessary, modify the Data Type.
Click the lightning bolt next to the Value list to choose the proper form element.
Instead, a typical Access database is a a collection of tables, plus a set of objects built around those tables — forms, reports, queries, and so on.
In addition, those objects must adhere to a set of design principles or the database will either work poorly or fail altogether.
In the Database section, choose your database connection from the Connection list.
This setting allows you to update all of your records at once. When the Update Multiple Records wizard opens, you’ll first select the event to execute the server behavior from the Trigger list. In the Repeated form list, select Repeat Region (rs Cat).4.
In the Repeat Regions dialog box, make sure your recordset is displayed and set Show to All records.
From the Server Behaviors panel, click and choose Repeat Region.5.
Read this section if you are new to Access or unfamiliar with the concepts behind relational databases. If IGNORE is provided, all errors encountered during the update are ignored.If an update on a row would result in a violation of a primary key or unique index, the update on that row is not performed.This is the way I am doing it and it is working but as you will see I have to interact with the database more than once which is not good :/ As you can see I am creating the record to store the data captured from the form but then I am having to read the record back in to update it with the $member_id.Is there a better, more efficient, way of doing this?
