Page Comparison

...

1. Open the Configure Part dialog for a form and select the Add Parts... button.
   • See Modifying a Form Layout for instructions on how to access the Configure Part dialog.
     
     
2. Click the New Part button to open the wizard.
3. Select View from the Tab Type drop-down list, and click Next to -continue.
4. Enter a name for the tab in the field provided and click Next.
5. Select the source for the view: Stored View or SQL View.
   • If you select Stored View, you specify an existing view that is used to display information from the related records.
   • If you select SQL View, you specify a SQL statement that returns information from the related service. This option is for advanced users and only creates list views.
     
     
6. Enter the related service in the Select Service link box.
   • The service you specify in this field must have a link box on its form that corresponds to the current service whose form you are modifying.
     
     
7. If you selected Stored View as the View Type, do the following:
   • Enter an existing view of the service you specified in View field.
   1. • If you use the Find dialog to locate a view, note that it will only display the existing views for your user for the service specified in the Select Service field.
        
        
   • Select the Related Field that the system will use to filter records in the Select Service.
   1. • For example, in, the system will filter the Committees view to only displays those committees where CoordinatorID equals the ID of the Employees record that is currently open.
      • If the Related Field field does not populate automatically, you entered an invalid option in the Select Service field. In this case, specify a different -service.
      • Note that when you use the Stored View option, new records opened from this view will have the Related Field automatically populated with the ID of the record from which you opened the form.
        
        
8. If you selected SQL View as the View Type, do the following:
   • Enter a SQL statement in the text field provided.
   1. • The SQL statement should query the base view of the service in the Select Service field and filter the results based on a field related to the current entity.
        
        
9. Click Next to continue.
10. Click Finish to create the new part and return to the Select Part dialog.
11. Select the new View Part and click OK.

12. The form loads and includes the new tab, as in the figure “Coordinator For...” tab now appears on the Employees form and displays the list of Committees for which the employee is the coordinator.

Image Modified