When the M2M facility is turned on (the default setting) the name entered in the Table Object field is resolved in the following sequence:
- The M2M table is searched. If an entry in this table is found that matches the entered Table Object name, then the Data Table and View names are obtained from this entry.
- Otherwise, the available tableBASE libraries are searched for a View with the same name as the entered Table Object name.
- If a View is found in Step 2, and that View contains the name of the Data Table it is explicitly associated with, then that name is used to locate the Data Table.
- Otherwise, if a View is found in Step 2, but it does not explicitly contain the associated Data Table name, then the Table Object name entered by the user is used to locate the Data Table.
- Otherwise, the available tableBASE libraries are searched for a Data Table with the same name as the entered Table Object name. If the View name is specified within the Data Table definition, then that name is used to locate the View. Otherwise, an error message will be issued.
When M2M is turned off, separate fields appear so that both the View name and the Data Table name may be specified explicitly by the user.
- However, if the View name is cleared, then, the Data Table is located using the entered Data Table name.
If the Data Table’s definition names the associated View, then that name is used to locate the View. Otherwise, the View with the same name as the Data Table is located.
- If the Data Table name is cleared, then, the View is located using the entered View name.
If the View explicitly names the associated Data Table, then that name is used to locate the Data Table. Otherwise, the Data Table with the same name as the View is located.