Required Indexes for CursorAdapters

For each CursorAdapter you create or add to the Data Builder, you must create the following index tag definitions if you plan to use the CursorAdapter for Related Forms, a One-to-Many Form or a Related Pages form. See the Related Forms chapter for a complete description of VPM Enterprise’s Related Forms feature. See the Creating Forms: The Builders chapter for descriptions of the VPME One-to-Many and Related Pages forms.

1. Primary Key Index:

Create an index tag definition for a CursorAdapter’s primary key field(s). Make sure that you check the VPM Primary check box on the primary key’s index tag Edit page.

2. Child CursorAdapter / Foreign Key Indexes: 

Child CursorAdapter indexes require special construction. If you’re not familiar with the term “child CursorAdapter”, see What Is a Parent? What is a Child?.

·       Foreign Key Tag: For every child CursorAdapter, create an index for the foreign key that links child records to the primary key in the child’s parent table or CursorAdapter. 

Important: The foreign key tag expression must not contain any other fields but the foreign key fields. You will need the foreign key tag when you set up Referential Validation for a foreign key. See Referential Validation.

·       Child CursorAdapter Indexes Used in Toolbar Order Control: The VPM Enterprise Form Toolbar provides an Order control (see Order) that lets users change the order of the records displayed on a form. The Order control lets users change the record order by selecting from a list of indexes that you choose to display on the Order dialog. See Index Tags and Toolbar Order Control to learn how to choose indexes for the Order dialog.

More:

CursorAdapter Utilities