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.

    • Select the name of the Edit button or icon on the page. Then click the 'Button actions' in the Properties sheet.
    • In the Properties dialog, select the Redirect option and click on the Edit button.
    • Now 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.