|
| How To: Display a multi-table join |
| Article Type | How To |
| Title | Display 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 Reviewed | November 28, 2006 15:42:03 |
|
|
