Search these areas:
Help
Support Forums
Product Info



-Introduction
-DataWeb: What's New
-Creating an Application
-The DataWeb Designer
-Application Management
-Data Tables
-Data Tables
-Views
-Templates
-Components
-Data Analysis
-Members
-Security
-Importing
-Exporting
-FTP
-JavaScript
-Object Model
-Full-Text Search
-Domain and Email Hosting
-HotBlock Modules
-Account Management
-Glossary
-New Responsive UI Module





DataWeb Help
Support Forums
Tutorial
Script Library
Knowledge Base

Home > Support

KnowledgeBase


How To: Display the value of a foreign field in view script
Article TypeHow To
TitleDisplay the value of a foreign field in view script
<i>How do I use #substitution# syntax to display the value of a field on a related table? My lookup field is called "CustId". #record.custId# outputs the rowId of the customer table. I'd like to display the customer's first name instead.</i><br />
<br />
Reference the field with the <a href="http://help.westside.com/default.view?Topic=views/vaddingscripts">record object in your view script</a>:<br />
<br />
1. Make sure your dataregion contains the field on your related table you'd like to display.<br />
For example: &lt;ws:field name="custid">&lt;ws:select displayfield="firstName" />&lt/ws:field><br />
<br />
2. reference this value with the record object: #record['custId:firstName']#<br />
Last ReviewedFebruary 20, 2015 14:06:17

  
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
DataWeb, 720 North 10th Street, A #145, Renton, Washington 98057 *425-583-5970* Fax 484-770-4706* Email Us