Reference Field

Reference Field

Reference field stores a reference to a field on another table.

e.g. The STATE field on a Task table is reference to User[sys_user] table.

When you define a reference field, system creates the relation between two tables. Adding ref fields to a form makes the other field in ref table available to the form.

Ex.1- Adding reference field on OL billing form and Ref. table is User. Using type reference.

Sol. Open OL Billing Form -> Right click -> Configure -> Dictionary -> then below form will appear -> Click on advance view -> Selet USER (table name) in Reference tab -> Update.

 

Then go to USER table ->

 

 

->Go to Column FIRST NAME

 

 

->Select DISPLAY VALUE to TRUE->Update->Again Open OL billing Form ->Click on magnifier symbol in front of label USER->O/P->You will see the below window-> then click on any value->only the first name will appear in USER tab-> e.g.Bella1