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

Support Forum

(More)How do I show just one record when clicking on a lookup item?
KevinNicholls asked:
Extension of discussion# 266

Suppose the field in my data region is a bound field like


And I want that record item to link to

and show only the record for just that supplier? (by the way, my syntax does not work)
  dougl responded:
  I'm going to recreate your table structure to make sure the syntax in my example is correct. In the meantime, check out:
  dougl responded:

<a href="/supplier/default.view?Supplier_Name=#record['DealID:SupplierContactID:SupplierID:Supplier_Name']#"><ws:field name="DealID:SupplierContactID:SupplierID:Supplier_Name"><ws:caption>Supplier_Name</ws:caption></ws:field></a>
  matthewb responded:
  You might want to link on the PK of the suppliers table.  which would look like

<ws:field name="DealID:SupplierContactID:SupplierID" displaymodes="never" />
<a href="/supplier/default.view?SupplierID=#record['DealID:SupplierContactID:SupplierID']#"><ws:field name="DealID:SupplierContactID:SupplierID:Supplier_Name"><ws:caption>Supplier_Name</ws:caption></ws:field></a>
  dougl responded:
  also consider the following code to display 20 records when a view is in grid mode and only 1 record when a view is in all other modes:

      var strMode = request.getParameter( "_mode", "grid" );
      var iPageSize = strMode.toLowerCase() == "grid" ? 20 : 1;
  KevinNicholls responded:
  Doug- Matt

Thanks guys- works like a charm
  dougl responded:
  DataWeb considers this issue closed.
If you have additional questions or comments about this issue, please open it again.
If you have questions about a different topic please open a new support question.

DataWeb Support
  Please Log On
or create your own DataWeb Account.
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