</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">TileControl for WinForms</div> <div id="PageTitle"><div id="PageTitleText">Step 4 of 8: Preparing the Data Schema</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="Data Binding Overview.html">Data Binding Overview</a> > <a href="Databinding TutorialCreatingaComplex.html">Databinding Tutorial - Creating a Complex Databound TileControl</a> > Step 4 of 8: Preparing the Data Schema</td></tr></table></div> <div id="BodyContent"> <p class="MsoBodyText">In this step you will create a <b style="mso-bidi-font-weight: normal;">Categories_Product</b> and a <b style="mso-bidi-font-weight: normal;">Suppliers_Product</b> relation for the <b style="mso-bidi-font-weight: normal;">DataSet1</b>.</p> <ol> <li> <div> Take the <strong>CategoryID</strong> field with the mouse in the Categories table and drag&drop it to the <strong>CategoryID</strong> field in the Products table. You'll see the following window that creates a new relation between two tables: </div> </li> </ol> <blockquote style="margin-right: 0px;" dir="ltr"> <p class="C1HContinue"><img border="0" alt="" src="DocumentsGraphics/RelationDialogBox.png"></p> </blockquote> <ol style="counter-reset: item 1;" start="2"> <li>Take the <strong>SupplierID</strong> field with the mouse in the Suppliers table and drag&drop it to the <strong>SupplierID</strong> field in the Products table.</li> </ol> <blockquote style="margin-right: 0px;" dir="ltr"> <p class="C1HContinue">You'll see the following window that creates a new relation between two tables:</p> <p class="C1HContinue"><img border="0" alt="" src="DocumentsGraphics/RelationSuppliers.png"></p> </blockquote> <p class="C1HContinue"> <p class="C1HContinue"> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a target="_blank" href="http://our.componentone.com/groups/">Product Support Forum</a> | <a target="_blank" href="http://feedback.componentone.com/forums/255782-winforms-documentation">Documentation Feedback</a> </div> </body> </html>