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 a multi-table join
Article TypeHow To
TitleDisplay a multi-table join
<i>How do I show the results of a query from a join table? For example, my customers table contains the fields "CustomerName", "CustomerAddress" and "CustomerPhone". My orders table contains the fields "OrderAmount", "OrderDate", and a lookup to the customer table, "CustID". How do I display Order data and data on the related Customer in the same view?</i><br />
<br />
Insert a multiple <a href="http://support.dataweb.com/default.view?Topic=views/vpropertyref/field">fields</a> from a <a href="http://support.dataweb.com/default.view?Topic=datatables/lookup/dtlookups">related table</a>:<br />
<br />
When you do Insert/Existing Fields from the view designer, Lookup field names show as Hyperlinks in the field list. E.g. CustId is a hyperlink. If you click on that hyperlink you will see checkboxes for fields in the Customers table. Just check off those fields and they will be added to the view with the correct join.<br />
Last ReviewedNovember 28, 2006 15:42:03

  
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