Technote Details :: NeXTensio form displays other fields than its associated list

I applied the Create NeXTensio List Wizard and configured it to get data from a joined recordset. In the form page, I applied the Create NeXTensio Form Wizard. When I open the form page in the browser, from the list page (to either add or edit a record), I notice it does not display the corresponding information from the NeXTensio list.

You will face this issue if you are in the following situation:

1. You create a NeXTensio list setting it to get data from a recordset (in the first step of the wizard).
2. The recordset you use is a joined one, using at least two tables (e.g. categories and products, companies and contacts, continents and countries etc.). Say the tables used are A and B.
3. When asked for the primary key (in the list configuration), you select the primary key column from table A.
4. Then you create the NeXTensio form, based on table B. A NeXTensio form can only get data from tables, and not recordsets as well.
5. Obviously, as the primary key for the form you select the primary key from this table, B.

With these settings made, when you try to edit one of the list entries, the form page you are redirected to does not display the expected fields to be updated. It actually displays an insert form for table B. This happens because the primary key from table A (list table) is passed to the form page as an URL parameter. But the form page cannot recognize it, as it expects the primary key from table B.

In less words, the reason for this issue is the fact that the primary keys set when configuring the NeXTensio list and form do not coincide.

In order to avoid this issue, please make sure to set the same primary key column in both the list and form. This means that the NeXTensio form should be based on a specific table from the list joined recordset, namely the one that contains the primary key set in the list. This is necessary because the list and form are connected through a primary key; so if it is not the same one, the logical correspondence is lost.

For more information on this, please consult the NeXTensio list and form configuration in the help files.