|
| How To: Display the value of a foreign field in view script |
| Article Type | How To |
| Title | Display 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: <ws:field name="custid"><ws:select displayfield="firstName" /></ws:field><br />
<br />
2. reference this value with the record object: #record['custId:firstName']#<br /> |
| Last Reviewed | February 20, 2015 14:06:17 |
|
|
