Configuring a Special Edit Record Page

The table that contains the record you are trying to edit is either a non-physical table (i.e. a View or a Query), or has no primary key. However, you can still create an Edit button for it by binding the Edit Icon and providing a Primary Key from a referenced physical table.

This will enable you to edit a record from one of the referenced physical tables. For example, you could bind the Edit Icon for the 'Alphabetical list of products' view from the Northwind database so that it displays a Products record for editing.

To bind the Edit button or icon to an Edit Record page:

  1. If you have not yet created an Edit Record page, use the Application Wizard to create one.

  2. Go to the Application Explorer tab, navigate in the tree to the page that contains the Edit button or icon, then click the Properties button on the tool bar.

    • Select the name of the Edit button or icon in the tree.
    • On the Bindings tab, modify the Redirect URL to point to your Edit Record page.
      Example: ../MyPages/MyEditRecordPage.aspx?QueryStringParam={0}

    • The Redirect parameter should reference the field that is a Primary Key for an associated physical table.
      Example: "FV:ProductID"

  3. Save changes and rebuild the application.