Adding and Updating Reference Field

 

Reference fields are used to display the information on the form.

Reference field will not get stored in the database. They are computed by using some fields stored in the database and displayed on the forms.

You can add reference field on master forms,master detaill forms and RDLC reports.

To add reference field on master forms open the master form on which you want to add reference fieldand click on Reference field button.

To add reference field on master detail forms open the master detail form on which you want to add reference fieldand click on Reference field button.

To add reference field on RDLC reports open the RDLC reports on which you want to add reference fieldand clickon Reference field button.

Following are steps to add reference field

  1. Specify name of a reference field in the Name text box.
  2. Select data type from the Data Type combo box.
  3. Click on Add button.
  4. To update the reference field, double click on the reference field name, update the field and click on Update button.
  5. Click on Ok Button.

 

Related Topics

Update Master Form

Create and Update Master-Detail Form

Creating and Updating RDLC Reports

 

Example of Reference Field

Suppose you want to show list of  Customers belonging to the city when the city is selected and City and Customers are fields of different tables. Then you can make City as a Reference fIeld. (City and Customers are Combo boxes.)