Search these areas:
Support Forums
Product Info

-DataWeb: What's New
-Creating an Application
-The DataWeb Designer
-Application Management
-Data Tables
-Data Tables
-Data Analysis
-Object Model
-Full-Text Search
-Domain and Email Hosting
-HotBlock Modules
-Account Management
-New Responsive UI Module

DataWeb Help
Support Forums
Script Library
Knowledge Base

Home > Support


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="">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