To use SQL Assistant to query relations

In the Gas database schema, the feature class GA_FITTING has a relation to the GA_CONDITION_TBD feature class. Query the CONDITION and display it on the form.

  1. Open a project that has access to a Gas database schema.
  2. Start the Form Designer.
  3. Add a Read-Only SQL Text Box.
  4. Click the SQL property and click to start the SQL Assistant.

    Under Relations, the related feature classes are displayed.

  5. Select a feature class in the tree view, and click to insert the select statement that retrieves the related value into the expression input box.
  6. Replace the * with the attribute you need, such as VALUE.