To display label text in the parent feature class

1. In the Infrastructure Administrator, do one of the following:
   • Click Enterprise and connect to the enterprise industry model. Open a project.
   • Click File and open an industry model drawing or template.
2. Expand the Industry Model node and click Form Designer.

   The form designer is displayed in the right pane. The topics and feature classes are displayed in the form explorer.

3. In the form explorer, select a feature class, select the Form Type, such as Default, and click Edit.
4. In the Designer dialog box, on the designer toolbar, click .
5. Click OK for the name.
6. In the left pane, click the Properties tab.
7. Select the UnAvailableValue property and enter the following text: No label text available.
8. Select the SQL property and click to open the SQL Assistant.
9. In the SQL Assistant dialog box, under Relations, expand the feature class, and click the label feature class.

   The SQL expression is inserted into the expression input box.

10. Replace the asterisk (*) in the SQL expression with LABEL_TEXT. The result is:

    select LABEL_TEXT from <featureclass>_TBL
    

    where FID_PARENT in (select FID from <featureclass> where fid={fid})
    

11. Click Execute to run the SQL statement and check the syntax.
12. Exit the SQL Assistant and the Form Designer.
13. In the feature class form, browse for the records. If a record has no label, the UnAvailableValue is displayed instead of the label text.

Note: A feature can have more than one label, which is not considered in the above example.

Example: SQL label statement to display the area of an area topology in the centroid feature class

select ROUND(bts.EXACT_AREA,6)

from BF_TSUR bts, BF_TCEN btc

where btc.FID_TSUR = bts.FID

and btc.FID_CENTROID = {FID}

select exact_area from LM_T_LANDUSE_TSUR 

 where FID in (select FID_TSUR from LM_T_LANDUSE_TCEN

 where FID_CENTROID in (select FID from LM_LANDUSE

 where fid={fid}))