Microsoft: Access Tables and Relationships

<!DOCTYPE html> <html id="XF" lang="en-US" dir="LTR" data-app="public" data-template="forum_view" data-container-key="node-700" data-content-key="forum-700" data-logged-in="false" data-cookie-prefix="xf_" data-csrf="1732697272,a54730b8ba846e256320b0017b115787" class="has-no-js template-forum_view XenBase layout-classic style-light sidebar-right xb-toggle-default xb-sidebar-show" > <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover">  <script> var dimensionValue1 = 'Programmers'; var dimensionValue2 = 'DBMS Packages'; var dimensionValue3 = 'Microsoft: Access Tables and Relationships'; window.dataLayer = window.dataLayer || []; window.dataLayer.push({ 'Area' : dimensionValue1, 'Category' : dimensionValue2, 'Forum' : dimensionValue3 }); </script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-MMC9PJ9');</script>   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-TZQ8TVZR');</script>   <script type="text/javascript"> adroll_adv_id = "KCG7QJRNGNEX3GEZSJPEFG"; adroll_pix_id = "HNHCAFVMNNC7FBZP3GMMLE"; adroll_version = "2.0"; (function(w, d, e, o, a) { w.__adroll_loaded = true; w.adroll = w.adroll || []; w.adroll.f = [ 'setProperties', 'identify', 'track', 'identify_email' ]; var roundtripUrl = "https://s.adroll.com/j/" + adroll_adv_id + "/roundtrip.js"; for (a = 0; a < w.adroll.f.length; a++) { w.adroll[w.adroll.f[a]] = w.adroll[w.adroll.f[a]] || (function(n) { return function() { w.adroll.push([ n, arguments ]) } })(w.adroll.f[a]) } e = d.createElement('script'); o = d.getElementsByTagName('script')[0]; e.async = 1; e.src = roundtripUrl; o.parentNode.insertBefore(e, o); })(window, document); adroll.track("pageView"); </script> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4401622383960692" crossorigin="anonymous"></script>   <script async src="https://securepubads.g.doubleclick.net/tag/js/gpt.js"></script> <script> window.googletag = window.googletag || {cmd: []}; googletag.cmd.push(function() { var pathParts = window.location.pathname.substr(1).split('/'); var mapLeaderboard = googletag.sizeMapping() .addSize([1024, 200], [728, 90]) .addSize([0, 0], [300, 250]) .build(); var mapWallpaper = googletag.sizeMapping() .addSize([1024, 200], [1, 1]) .addSize([0, 0], [[1, 1]]) .build(); var gptSlots = []; googletag.defineSlot('/5272491/dw_network/tektips_customsearchbox', [300, 90], 'div-gpt-tektips_customsearchbox').addService(googletag.pubads()); gptSlots[1] = googletag.defineSlot('/5272491/dw_network/tektips_thread1', [728, 90], 'div-gpt-tektips_thread1').defineSizeMapping(mapLeaderboard).addService(googletag.pubads()); gptSlots[2] = googletag.defineSlot('/5272491/dw_network/tektips_thread2', [728, 90], 'div-gpt-tektips_thread2').defineSizeMapping(mapLeaderboard).addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_thread3', [[728, 90]], 'div-gpt-tektips_thread3').addService(googletag.pubads()); gptSlots[3] = googletag.defineSlot('/5272491/dw_network/tektips_wallpaper', [1, 1], 'div-gpt-tektips_wallpaper').defineSizeMapping(mapWallpaper).addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_sidebar1', [[300, 250], [300, 600]], 'div-gpt-tektips_sidebar1').addService(googletag.pubads()); googletag.defineSlot('/5272491/dw_network/tektips_sidebarbottom', [[300, 250], [300, 600]], 'div-gpt-tektips_sidebarbottom').addService(googletag.pubads()); googletag.pubads().enableSingleRequest(); googletag.pubads().collapseEmptyDivs(); googletag.pubads().setTargeting('articletitle', pathParts[0] ? pathParts[0] : 'home-page'); googletag.enableServices(); }); </script>  <title>Microsoft: Access Tables and Relationships | Tek-Tips</title> <link rel="manifest" href="/webmanifest.php"> <meta name="theme-color" content="#647ec4" /> <meta name="apple-mobile-web-app-title" content="Tek-Tips Information Technology Professional Forums"> <link rel="canonical" href="https://www.tek-tips.com/forums/microsoft-access-tables-and-relationships.700/" /> <link rel="alternate" type="application/rss+xml" title="RSS feed for Microsoft: Access Tables and Relationships" href="/forums/microsoft-access-tables-and-relationships.700/index.rss" /> <link rel="next" href="/forums/microsoft-access-tables-and-relationships.700/page-2" /> <meta property="og:site_name" content="Tek-Tips" /> <meta property="og:type" content="website" /> <meta property="og:title" content="Microsoft: Access Tables and Relationships" /> <meta property="twitter:title" content="Microsoft: Access Tables and Relationships" /> <meta property="og:url" content="https://www.tek-tips.com/forums/microsoft-access-tables-and-relationships.700/" /> <link rel="preconnect" href="https://fonts.googleapis.com"><link rel="preconnect" href="https://fonts.gstatic.com" crossorigin><link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;700&display=swap" rel="stylesheet"> <link rel="preload" href="/styles/fonts/fa/fa-light-300.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="preload" href="/styles/fonts/fa/fa-solid-900.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="preload" href="/styles/fonts/fa/fa-brands-400.woff2?_v=5.15.3" as="font" type="font/woff2" crossorigin="anonymous" /> <link rel="stylesheet" href="/css.php?css=public%3Anormalize.css%2Cpublic%3Afa.css%2Cpublic%3Acore.less%2Cpublic%3Aapp.less&s=3&l=1&d=1731063743&k=0e1337d98c8845c72b8d3c46d22feb00bc113906" /> <link rel="stylesheet" href="/css.php?css=public%3Anotices.less%2Cpublic%3Astructured_list.less%2Cpublic%3AsvESE_autocomplete.less%2Cpublic%3Axb.less%2Cpublic%3Axb_search.less%2Cpublic%3Axb_sidebar_login.less%2Cpublic%3Axb_welcome.less%2Cpublic%3Axc_votes_button.less%2Cpublic%3Aextra.less&s=3&l=1&d=1731063743&k=b39b921675a3efd3e986552a843b61efc85edef8" /> <script src="/js/xf/preamble.min.js?_v=e65b7ca0"></script> </head> <body data-template="forum_view">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-MMC9PJ9" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>   <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-TZQ8TVZR" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="p-pageWrapper" id="top"> <div class="p-pageWrapper--helper"></div> <div class="xb-page-wrapper xb-canvas-menuActive"> <div class="xb-page-wrapper--helper"></div> <header class="p-header" id="header"> <div class="p-header-inner"> <div class="p-header-content"> <div class="p-header-logo p-header-logo--image"> <a href="https://www.tek-tips.com"> <img src="/styles/nova/tek-tips/header-logo.png" srcset="" alt="Tek-Tips" width="" height="" /> </a> </div> <div class="xb-searchWrapper" id="xb-searchWrapper" tabindex="0"> <form action="/search/search" id="xbSearch" data-xf-init="quick-search" data-autocomplete-filter="null" data-autocomplete-filter="null" class="xb-search" method="post" data-no-auto-focus="true"> <input type="text" class="input" name="keywords" placeholder="Search…" aria-label="Search" /> <div class="menu menu--structural menu--search" aria-hidden="true"> <div class="menu-content"> <div class="menu-row"> <select name="constraints" class="js-quickSearch-constraint input" aria-label="Search within"> <option value="">Everywhere</option> <option value="{"search_type":"post"}">Threads</option> <option value="{"search_type":"post","c":{"nodes":[700],"child_nodes":1}}">This forum</option> </select> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[container_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles and first posts only</span></label> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[title_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles only</span></label> </div> <div class="menu-row"> <div class="inputGroup"> <span class="inputGroup-text" id="ctrl_search_menu_by_member">By:</span> <input type="text" class="input" name="c[users]" data-xf-init="auto-complete" placeholder="Member" aria-labelledby="ctrl_search_menu_by_member" /> </div> </div> <div class="menu-footer"> <span class="menu-footer-controls"> <button type="submit" class="button--primary button button--icon button--icon--search"><span class="button-text">Search</span></button> <a href="/search/" class="button"><span class="button-text">Advanced search…</span></a> </span> </div> <input type="hidden" name="_xfToken" value="1732697272,a54730b8ba846e256320b0017b115787" /> </div> </div> </form> </div> </div> </div> </header> <div class="xb-content-wrapper"> <div class="navigation-helper"></div> <div class="p-navSticky p-navSticky--primary" data-xf-init="sticky-header"> <div class="p-nav--wrapper"> <nav class="p-nav"> <div class="p-nav-inner"> <button type="button" class="button--plain p-nav-menuTrigger button" data-xf-click="off-canvas" data-menu=".js-headerOffCanvasMenu" tabindex="0" aria-label="Menu"><span class="button-text"> <i aria-hidden="true"></i> </span></button> <div class="p-nav-smallLogo"> <a href="https://www.tek-tips.com"> <img src="/styles/nova/tek-tips/header-logo.png" srcset="" alt="Tek-Tips" width="" height="" /> </a> </div> <div class="p-nav-scroller hScroller" data-xf-init="h-scroller" data-auto-scroll=".p-navEl.is-selected"> <div class="hScroller-scroll"> <ul class="p-nav-list js-offCanvasNavSource"> <li class="navhome"> <div class="p-navEl " > <a href="https://www.tek-tips.com" class="p-navEl-link " data-xf-key="1" data-nav-id="home">Home</a> </div> </li> <li class="navforums"> <div class="p-navEl is-selected" data-has-children="true"> <a href="/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="forums">Forums</a> <a data-xf-key="2" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/whats-new/posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="newPosts">New posts</a> <a href="/search/?type=post" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="searchForums">Search forums</a> <a href="/forums/microsoft-access-tables-and-relationships.700/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="0">Forum</a> <a href="/forums/700/faqs/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy faqLink" data-nav-id="1">FAQs</a> <a href="/forums/700/links/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="2">Links</a> <a href="/forums/700/mvps/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy mvpLink" data-nav-id="3">MVPs</a> </div> </div> </div> </li> <li class="navwhatsNew"> <div class="p-navEl " data-has-children="true"> <a href="/whats-new/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="whatsNew">What's new</a> <a data-xf-key="3" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/whats-new/posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="whatsNewPosts">New posts</a> <a href="/whats-new/profile-posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="whatsNewProfilePosts">New profile posts</a> <a href="/whats-new/latest-activity" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="latestActivity">Latest activity</a> </div> </div> </div> </li> <li class="navmembers"> <div class="p-navEl " data-has-children="true"> <a href="/members/" class="p-navEl-link p-navEl-link--splitMenu " data-nav-id="members">Members</a> <a data-xf-key="4" data-xf-click="menu" data-menu-pos-ref="< .p-navEl" class="p-navEl-splitTrigger" role="button" tabindex="0" aria-label="Toggle expanded" aria-expanded="false" aria-haspopup="true"></a> <div class="menu menu--structural" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <a href="/online/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="currentVisitors">Current visitors</a> <a href="/whats-new/profile-posts/" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " rel="nofollow" data-nav-id="newProfilePosts">New profile posts</a> <a href="/search/?type=profile_post" class="menu-linkRow u-indentDepth0 js-offCanvasCopy " data-nav-id="searchProfilePosts">Search profile posts</a> </div> </div> </div> </li> </ul> </div> </div> <div class="p-nav-opposite"> <div class="p-navgroup p-account p-navgroup--guest"> <a href="/login/" class="p-navgroup-link p-navgroup-link--textual p-navgroup-link--logIn" data-xf-click="overlay" data-follow-redirects="on"> <span class="p-navgroup-linkText">Log in</span> </a> <a href="/register/" class="p-navgroup-link p-navgroup-link--textual p-navgroup-link--register" data-xf-click="overlay" data-follow-redirects="on"> <span class="p-navgroup-linkText">Register</span> </a> </div> <div class="p-navgroup p-discovery"> <a href="/whats-new/" class="p-navgroup-link p-navgroup-link--iconic p-navgroup-link--whatsnew" aria-label="What's new" title="What's new"> <i aria-hidden="true"></i> <span class="p-navgroup-linkText">What's new</span> </a> <a href="/search/" class="p-navgroup-link p-navgroup-link--iconic p-navgroup-link--search" data-xf-click="menu" data-xf-key="/" aria-label="Search" aria-expanded="false" aria-haspopup="true" title="Search"> <i aria-hidden="true"></i> <span class="p-navgroup-linkText">Search</span> </a> <div class="menu menu--structural menu--wide" data-menu="menu" aria-hidden="true"> <form action="/search/search" method="post" class="menu-content" data-xf-init="quick-search" data-autocomplete-filter="["post"]"> <h3 class="menu-header">Search</h3> <div class="menu-row"> <div class="inputGroup inputGroup--joined"> <input type="text" class="input" name="keywords" placeholder="Search…" aria-label="Search" data-menu-autofocus="true" /> <select name="constraints" class="js-quickSearch-constraint input" aria-label="Search within"> <option value="">Everywhere</option> <option value="{"search_type":"post"}">Threads</option> <option value="{"search_type":"post","c":{"nodes":[700],"child_nodes":1}}">This forum</option> </select> </div> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[container_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles and first posts only</span></label> </div> <div class="menu-row"> <label class="iconic"><input type="checkbox" name="c[title_only]" value="1" /><i aria-hidden="true"></i><span class="iconic-label">Search titles only</span></label> </div> <div class="menu-row"> <div class="inputGroup"> <span class="inputGroup-text" id="ctrl_search_menu_by_member">By:</span> <input type="text" class="input" name="c[users]" data-xf-init="auto-complete" placeholder="Member" aria-labelledby="ctrl_search_menu_by_member" /> </div> </div> <div class="menu-footer"> <span class="menu-footer-controls"> <button type="submit" class="button--primary button button--icon button--icon--search"><span class="button-text">Search</span></button> <a href="/search/" class="button"><span class="button-text">Advanced search…</span></a> </span> </div> <input type="hidden" name="_xfToken" value="1732697272,a54730b8ba846e256320b0017b115787" /> </form> </div> </div> </div> </div> </nav> </div> </div> <div class="p-sectionLinks--wrapper"> <div class="p-sectionLinks"> <div class="p-sectionLinks-inner"> <div class="hScroller" data-xf-init="h-scroller"> <div class="hScroller-scroll"> <ul class="p-sectionLinks-list"> <li> <div class="p-navEl " > <a href="/whats-new/posts/" class="p-navEl-link " data-xf-key="alt+1" data-nav-id="newPosts">New posts</a> </div> </li> <li> <div class="p-navEl " > <a href="/search/?type=post" class="p-navEl-link " data-xf-key="alt+2" data-nav-id="searchForums">Search forums</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/microsoft-access-tables-and-relationships.700/" class="p-navEl-link " data-xf-key="alt+3" data-nav-id="0">Forum</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/faqs/" class="p-navEl-link faqLink" data-xf-key="alt+4" data-nav-id="1">FAQs</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/links/" class="p-navEl-link " data-xf-key="alt+5" data-nav-id="2">Links</a> </div> </li> <li> <div class="p-navEl " > <a href="/forums/700/mvps/" class="p-navEl-link mvpLink" data-xf-key="alt+6" data-nav-id="3">MVPs</a> </div> </li> </ul> </div> </div> <div class="p-sectionLinks-right"> </div> </div> </div> </div> <div class="offCanvasMenu offCanvasMenu--nav js-headerOffCanvasMenu" data-menu="menu" aria-hidden="true" data-ocm-builder="navigation"> <div class="offCanvasMenu-backdrop" data-menu-close="true"></div> <div class="offCanvasMenu-content"> <div class="offCanvasMenu-content--inner"> <div class="offCanvasMenu-header"> Menu <a class="offCanvasMenu-closer" data-menu-close="true" role="button" tabindex="0" aria-label="Close"></a> </div> <div class="p-offCanvasRegisterLink"> <div class="offCanvasMenu-linkHolder"> <a href="/login/" class="offCanvasMenu-link" data-xf-click="overlay" data-menu-close="true"> Log in </a> </div> <hr class="offCanvasMenu-separator" /> <div class="offCanvasMenu-linkHolder"> <a href="/register/" class="offCanvasMenu-link" data-xf-click="overlay" data-menu-close="true"> Register </a> </div> <hr class="offCanvasMenu-separator" /> </div> <div class="offCanvasMenu-subHeader">Navigation</div> <div class="js-offCanvasNavTarget"></div> <div class="offCanvasMenu-installBanner js-installPromptContainer" style="display: none;" data-xf-init="install-prompt"> <div class="offCanvasMenu-installBanner-header">Install the app</div> <button type="button" class="js-installPromptButton button"><span class="button-text">Install</span></button> <template class="js-installTemplateIOS"> <div class="overlay-title">How to install the app on iOS</div> <div class="block-body"> <div class="block-row"> <p> Follow along with the video below to see how to install our site as a web app on your home screen. </p> <p style="text-align: center"> <video src="/styles/default/xenforo/add_to_home.mp4" width="280" height="480" autoplay loop muted playsinline></video> </p> <p> <small><strong>Note:</strong> This feature may not be available in some browsers.</small> </p> </div> </div> </template> </div> <div class="offCanvasMenu-subHeader">More options</div> <div class="offCanvasMenu-linkHolder"> <a href="/misc/contact" class="offCanvasMenu-link" data-menu-close="true" data-nav-id="contactUs" data-xf-click="overlay">Contact us</a> </div> <div class="offCanvasMenu-linkHolder"> <a class="offCanvasMenu-link" data-menu-close="true" data-nav-id="closeMenu" role="button" tabindex="0" aria-label="Close">Close Menu</a> </div> </div> </div> </div> <div class="p-body"> <div class="p-body-inner"> <div class="xb-welcome-notice"> <div class="xb-welcome-notice--mask"> <div class="xb-welcome-notice--inner"> <div class="xb-welcome-notice--title"> <h3>Tek-Tips is the largest IT community on the Internet today!</h3> <h4>Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!</h4> </div> <div class="xb-welcome-notice--buttons"> <a href="/register/" class="button" data-xf-click="overlay" data-follow-redirects="on"><span class="button-text">Register</span></a> <a href="/login/" class="button--cta button" rel="nofollow" data-xf-click="overlay" data-menu-close="true"> <span class="button-text">Log in</span> </a> </div> </div> </div> </div>  <ul class="notices notices--block js-notices" data-xf-init="notices" data-type="block" data-scroll-interval="6"> <li class="notice js-notice notice--light" data-notice-id="15" data-delay-duration="0" data-display-duration="0" data-auto-dismiss="" data-visibility=""> <div class="notice-content"> <b>Congratulations <span><a href="/members/mike-lewis.388080/">Mike Lewis</a></span></b> on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go! </div> </li> </ul> <div style="text-align:center;"> <div class="inContentAd"><div id='div-gpt-tektips_thread1'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_thread1'); }); </script> </div> </div> </div><div> <div class="p-breadcrumbs--parent "> <ul class="p-breadcrumbs " itemscope itemtype="https://schema.org/BreadcrumbList"> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="https://www.tek-tips.com" itemprop="item"> <span itemprop="name">Home</span> </a> <meta itemprop="position" content="1" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/" itemprop="item"> <span itemprop="name">Forums</span> </a> <meta itemprop="position" content="2" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/#software.1001" itemprop="item"> <span itemprop="name">Software</span> </a> <meta itemprop="position" content="3" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/programmers.1004/" itemprop="item"> <span itemprop="name">Programmers</span> </a> <meta itemprop="position" content="4" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/dbms-packages.10027/" itemprop="item"> <span itemprop="name">DBMS Packages</span> </a> <meta itemprop="position" content="5" /> </li> </ul> </div> <noscript class="js-jsWarning"><div class="blockMessage blockMessage--important blockMessage--iconic u-noJsOnly">JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.</div></noscript> <div class="blockMessage blockMessage--important blockMessage--iconic js-browserWarning" style="display: none">You are using an out of date browser. It may not display this or other websites correctly.<br />You should upgrade or use an <a href="https://www.google.com/chrome/" target="_blank" rel="noopener">alternative browser</a>.</div>  <div class="p-body-header"> <div class="p-title "> <h1 class="p-title-value">Microsoft: Access Tables and Relationships</h1> </div> </div>  <div class="p-body-main p-body-main--withSidebar "> <div class="p-body-contentCol"></div> <div class="p-body-sidebarCol"></div> <div class="p-body-content">  <div id='div-gpt-tektips_wallpaper'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_wallpaper'); }); </script> </div> <div class="p-body-pageContent"> <div class="block " data-xf-init="" data-type="thread" data-href="/inline-mod/"> <div class="block-outer"><div class="block-outer-main"><nav class="pageNavWrapper pageNavWrapper--full "> <div class="pageNav pageNav--skipEnd"> <ul class="pageNav-main"> <li class="pageNav-page pageNav-page--current "><a href="/forums/microsoft-access-tables-and-relationships.700/">1</a></li> <li class="pageNav-page pageNav-page--later"><a href="/forums/microsoft-access-tables-and-relationships.700/page-2">2</a></li> <li class="pageNav-page pageNav-page--later"><a href="/forums/microsoft-access-tables-and-relationships.700/page-3">3</a></li> <li class="pageNav-page pageNav-page--skip pageNav-page--skipEnd"> <a data-xf-init="tooltip" title="Go to page" data-xf-click="menu" role="button" tabindex="0" aria-expanded="false" aria-haspopup="true">…</a> <div class="menu menu--pageJump" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <h4 class="menu-header">Go to page</h4> <div class="menu-row" data-xf-init="page-jump" data-page-url="/forums/microsoft-access-tables-and-relationships.700/page-%page%"> <div class="inputGroup inputGroup--numbers"> <div class="inputGroup inputGroup--numbers inputNumber" data-xf-init="number-box"><input type="number" pattern="\d*" class="input input--number js-numberBoxTextInput input input--numberNarrow js-pageJumpPage" value="4" min="1" max="302" step="1" required="required" data-menu-autofocus="true" /></div> <span class="inputGroup-text"><button type="button" class="js-pageJumpGo button"><span class="button-text">Go</span></button></span> </div> </div> </div> </div> </li> <li class="pageNav-page "><a href="/forums/microsoft-access-tables-and-relationships.700/page-302">302</a></li> </ul> <a href="/forums/microsoft-access-tables-and-relationships.700/page-2" class="pageNav-jump pageNav-jump--next">Next</a> </div> <div class="pageNavSimple"> <a class="pageNavSimple-el pageNavSimple-el--current" data-xf-init="tooltip" title="Go to page" data-xf-click="menu" role="button" tabindex="0" aria-expanded="false" aria-haspopup="true"> 1 of 302 </a> <div class="menu menu--pageJump" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <h4 class="menu-header">Go to page</h4> <div class="menu-row" data-xf-init="page-jump" data-page-url="/forums/microsoft-access-tables-and-relationships.700/page-%page%"> <div class="inputGroup inputGroup--numbers"> <div class="inputGroup inputGroup--numbers inputNumber" data-xf-init="number-box"><input type="number" pattern="\d*" class="input input--number js-numberBoxTextInput input input--numberNarrow js-pageJumpPage" value="1" min="1" max="302" step="1" required="required" data-menu-autofocus="true" /></div> <span class="inputGroup-text"><button type="button" class="js-pageJumpGo button"><span class="button-text">Go</span></button></span> </div> </div> </div> </div> <a href="/forums/microsoft-access-tables-and-relationships.700/page-2" class="pageNavSimple-el pageNavSimple-el--next"> Next <i aria-hidden="true"></i> </a> <a href="/forums/microsoft-access-tables-and-relationships.700/page-302" class="pageNavSimple-el pageNavSimple-el--last" data-xf-init="tooltip" title="Last"> <i aria-hidden="true"></i> <span class="u-srOnly">Last</span> </a> </div> </nav> </div></div> <div class="block-container"> <div class="block-filterBar"> <div class="filterBar"> <a class="filterBar-menuTrigger" data-xf-click="menu" role="button" tabindex="0" aria-expanded="false" aria-haspopup="true">Filters</a> <div class="menu menu--wide" data-menu="menu" aria-hidden="true" data-href="/forums/microsoft-access-tables-and-relationships.700/filters" data-load-target=".js-filterMenuBody"> <div class="menu-content"> <h4 class="menu-header">Show only:</h4> <div class="js-filterMenuBody"> <div class="menu-row">Loading…</div> </div> </div> </div> </div> </div> <div class="block-body"> <div class="structItemContainer"> <div class="structItemContainer-group js-threadList"> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1821069" data-author="TrekBiker"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/trekbiker.1570060/" class="avatar avatar--s" data-user-id="1570060" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="TrekBiker" class="avatar-u1570060-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/field-size-limit-access-365.1821069/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/field-size-limit-access-365.1821069/preview">Field size limit Access 365</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/trekbiker.1570060/" class="username " dir="auto" data-user-id="1570060" data-xf-init="member-tooltip">TrekBiker</a></li> <li class="structItem-startDate"><a href="/threads/field-size-limit-access-365.1821069/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2023-04-06T06:31:56+0100" data-time="1680759116" data-date-string="Apr 6, 2023" data-time-string="6:31 AM" title="Apr 6, 2023 at 6:31 AM">Apr 6, 2023</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>5</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>772</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/field-size-limit-access-365.1821069/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2023-04-07T10:36:19+0100" data-time="1680860179" data-date-string="Apr 7, 2023" data-time-string="10:36 AM" title="Apr 7, 2023 at 10:36 AM">Apr 7, 2023</time></a> <div class="structItem-minor"> <a href="/members/trekbiker.1570060/" class="username " dir="auto" data-user-id="1570060" data-xf-init="member-tooltip">TrekBiker</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/trekbiker.1570060/" class="avatar avatar--xxs" data-user-id="1570060" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="TrekBiker" class="avatar-u1570060-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1820222" data-author="JayRo71"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/saved-imoorts-problem-with-file-name.1820222/preview">Saved Imoorts problem with file name</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip">JayRo71</a></li> <li class="structItem-startDate"><a href="/threads/saved-imoorts-problem-with-file-name.1820222/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2023-01-25T12:28:26+0000" data-time="1674649706" data-date-string="Jan 25, 2023" data-time-string="12:28 PM" title="Jan 25, 2023 at 12:28 PM">Jan 25, 2023</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>10</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>331</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/saved-imoorts-problem-with-file-name.1820222/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2023-01-26T15:22:17+0000" data-time="1674746537" data-date-string="Jan 26, 2023" data-time-string="3:22 PM" title="Jan 26, 2023 at 3:22 PM">Jan 26, 2023</time></a> <div class="structItem-minor"> <a href="/members/andrzejek.1105365/" class="username " dir="auto" data-user-id="1105365" data-xf-init="member-tooltip">Andrzejek</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/andrzejek.1105365/" class="avatar avatar--xxs" data-user-id="1105365" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="Andrzejek" class="avatar-u1105365-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1820070" data-author="raywood1"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/raywood1.1102335/" class="avatar avatar--s" data-user-id="1102335" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="raywood1" class="avatar-u1102335-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/reducing-a-massive-linked-table.1820070/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/reducing-a-massive-linked-table.1820070/preview">Reducing a Massive Linked Table</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/raywood1.1102335/" class="username " dir="auto" data-user-id="1102335" data-xf-init="member-tooltip">raywood1</a></li> <li class="structItem-startDate"><a href="/threads/reducing-a-massive-linked-table.1820070/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2023-01-11T04:10:00+0000" data-time="1673410200" data-date-string="Jan 11, 2023" data-time-string="4:10 AM" title="Jan 11, 2023 at 4:10 AM">Jan 11, 2023</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>4</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>296</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/reducing-a-massive-linked-table.1820070/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2023-01-14T22:49:00+0000" data-time="1673736540" data-date-string="Jan 14, 2023" data-time-string="10:49 PM" title="Jan 14, 2023 at 10:49 PM">Jan 14, 2023</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1819554" data-author="TrekBiker"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/trekbiker.1570060/" class="avatar avatar--s" data-user-id="1570060" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="TrekBiker" class="avatar-u1570060-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/using-old-ids-as-autonumbers.1819554/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/using-old-ids-as-autonumbers.1819554/preview">Using old IDs as Autonumbers</a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/trekbiker.1570060/" class="username " dir="auto" data-user-id="1570060" data-xf-init="member-tooltip">TrekBiker</a></li> <li class="structItem-startDate"><a href="/threads/using-old-ids-as-autonumbers.1819554/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2022-11-28T11:09:02+0000" data-time="1669633742" data-date-string="Nov 28, 2022" data-time-string="11:09 AM" title="Nov 28, 2022 at 11:09 AM">Nov 28, 2022</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>6</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>299</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/using-old-ids-as-autonumbers.1819554/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2022-12-06T12:54:53+0000" data-time="1670331293" data-date-string="Dec 6, 2022" data-time-string="12:54 PM" title="Dec 6, 2022 at 12:54 PM">Dec 6, 2022</time></a> <div class="structItem-minor"> <a href="/members/andrzejek.1105365/" class="username " dir="auto" data-user-id="1105365" data-xf-init="member-tooltip">Andrzejek</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/andrzejek.1105365/" class="avatar avatar--xxs" data-user-id="1105365" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="Andrzejek" class="avatar-u1105365-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1813269" data-author="JayRo71"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/jayro71.1692646/" class="avatar avatar--s" data-user-id="1692646" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="JayRo71" class="avatar-u1692646-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/importing-only-unique-records-from-excel-tables.1813269/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/importing-only-unique-records-from-excel-tables.1813269/preview">Importing only unique records from excel tables </a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/jayro71.1692646/" class="username " dir="auto" data-user-id="1692646" data-xf-init="member-tooltip">JayRo71</a></li> <li class="structItem-startDate"><a href="/threads/importing-only-unique-records-from-excel-tables.1813269/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2022-01-06T15:46:59+0000" data-time="1641484019" data-date-string="Jan 6, 2022" data-time-string="3:46 PM" title="Jan 6, 2022 at 3:46 PM">Jan 6, 2022</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>10</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>386</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/importing-only-unique-records-from-excel-tables.1813269/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2022-01-11T19:15:36+0000" data-time="1641928536" data-date-string="Jan 11, 2022" data-time-string="7:15 PM" title="Jan 11, 2022 at 7:15 PM">Jan 11, 2022</time></a> <div class="structItem-minor"> <a href="/members/skipvought.166621/" class="username " dir="auto" data-user-id="166621" data-xf-init="member-tooltip">SkipVought</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/skipvought.166621/" class="avatar avatar--xxs avatar--default avatar--default--dynamic" data-user-id="166621" data-xf-init="member-tooltip" style="background-color: #cc3352; color: #f0c2cb"> <span class="avatar-u166621-s" role="img" aria-label="SkipVought">S</span> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1811302" data-author="MrStohler"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/mrstohler.415870/" class="avatar avatar--s" data-user-id="415870" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="MrStohler" class="avatar-u415870-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/beginner-q-how-to-separate-data-from-excel-into-related-tables-and-maintain-relationship.1811302/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/beginner-q-how-to-separate-data-from-excel-into-related-tables-and-maintain-relationship.1811302/preview">Beginner Q: How to separate data from Excel into related tables and maintain relationship?</a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/mrstohler.415870/" class="username " dir="auto" data-user-id="415870" data-xf-init="member-tooltip">MrStohler</a></li> <li class="structItem-startDate"><a href="/threads/beginner-q-how-to-separate-data-from-excel-into-related-tables-and-maintain-relationship.1811302/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2021-08-10T11:29:17+0100" data-time="1628591357" data-date-string="Aug 10, 2021" data-time-string="11:29 AM" title="Aug 10, 2021 at 11:29 AM">Aug 10, 2021</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>5</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>261</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/beginner-q-how-to-separate-data-from-excel-into-related-tables-and-maintain-relationship.1811302/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2021-08-11T16:01:36+0100" data-time="1628694096" data-date-string="Aug 11, 2021" data-time-string="4:01 PM" title="Aug 11, 2021 at 4:01 PM">Aug 11, 2021</time></a> <div class="structItem-minor"> <a href="/members/skipvought.166621/" class="username " dir="auto" data-user-id="166621" data-xf-init="member-tooltip">SkipVought</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/skipvought.166621/" class="avatar avatar--xxs avatar--default avatar--default--dynamic" data-user-id="166621" data-xf-init="member-tooltip" style="background-color: #cc3352; color: #f0c2cb"> <span class="avatar-u166621-s" role="img" aria-label="SkipVought">S</span> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1808404" data-author="Anthony343242"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/anthony343242.1697540/" class="avatar avatar--s" data-user-id="1697540" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="Anthony343242" class="avatar-u1697540-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/ms-access-union-all-with-attachment-data-type.1808404/preview">MS ACCESS UNION ALL with Attachment data type </a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/anthony343242.1697540/" class="username " dir="auto" data-user-id="1697540" data-xf-init="member-tooltip">Anthony343242</a></li> <li class="structItem-startDate"><a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2021-02-04T00:06:03+0000" data-time="1612397163" data-date-string="Feb 4, 2021" data-time-string="12:06 AM" title="Feb 4, 2021 at 12:06 AM">Feb 4, 2021</time></a></li> </ul> <span class="structItem-pageJump"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/page-2">2</a> </span> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>29</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>1K</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/ms-access-union-all-with-attachment-data-type.1808404/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2021-02-08T21:28:50+0000" data-time="1612819730" data-date-string="Feb 8, 2021" data-time-string="9:28 PM" title="Feb 8, 2021 at 9:28 PM">Feb 8, 2021</time></a> <div class="structItem-minor"> <a href="/members/anthony343242.1697540/" class="username " dir="auto" data-user-id="1697540" data-xf-init="member-tooltip">Anthony343242</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/anthony343242.1697540/" class="avatar avatar--xxs" data-user-id="1697540" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="Anthony343242" class="avatar-u1697540-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1807944" data-author="ameedoo3000"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/ameedoo3000.1675658/" class="avatar avatar--s" data-user-id="1675658" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="ameedoo3000" class="avatar-u1675658-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/send-a-message-to-an-email.1807944/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/send-a-message-to-an-email.1807944/preview">Send a message to an email</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/ameedoo3000.1675658/" class="username " dir="auto" data-user-id="1675658" data-xf-init="member-tooltip">ameedoo3000</a></li> <li class="structItem-startDate"><a href="/threads/send-a-message-to-an-email.1807944/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2021-01-11T12:31:51+0000" data-time="1610368311" data-date-string="Jan 11, 2021" data-time-string="12:31 PM" title="Jan 11, 2021 at 12:31 PM">Jan 11, 2021</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>627</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/send-a-message-to-an-email.1807944/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2021-01-11T13:25:28+0000" data-time="1610371528" data-date-string="Jan 11, 2021" data-time-string="1:25 PM" title="Jan 11, 2021 at 1:25 PM">Jan 11, 2021</time></a> <div class="structItem-minor"> <a href="/members/ameedoo3000.1675658/" class="username " dir="auto" data-user-id="1675658" data-xf-init="member-tooltip">ameedoo3000</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/ameedoo3000.1675658/" class="avatar avatar--xxs" data-user-id="1675658" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="ameedoo3000" class="avatar-u1675658-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1807066" data-author="03Explorer"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/03explorer.1060185/" class="avatar avatar--s" data-user-id="1060185" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="03Explorer" class="avatar-u1060185-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/preview">Refreshing a linked table (housed on MS SQL Server) now breaks</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/03explorer.1060185/" class="username " dir="auto" data-user-id="1060185" data-xf-init="member-tooltip">03Explorer</a></li> <li class="structItem-startDate"><a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2020-11-13T22:22:57+0000" data-time="1605306177" data-date-string="Nov 13, 2020" data-time-string="10:22 PM" title="Nov 13, 2020 at 10:22 PM">Nov 13, 2020</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>3</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>230</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/refreshing-a-linked-table-housed-on-ms-sql-server-now-breaks.1807066/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2020-12-02T15:23:21+0000" data-time="1606922601" data-date-string="Dec 2, 2020" data-time-string="3:23 PM" title="Dec 2, 2020 at 3:23 PM">Dec 2, 2020</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1806723" data-author="monkeysee"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/monkeysee.306740/" class="avatar avatar--s" data-user-id="306740" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="monkeysee" class="avatar-u306740-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/field-to-count-specific-records.1806723/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/field-to-count-specific-records.1806723/preview">Field to count specific records</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/monkeysee.306740/" class="username " dir="auto" data-user-id="306740" data-xf-init="member-tooltip">monkeysee</a></li> <li class="structItem-startDate"><a href="/threads/field-to-count-specific-records.1806723/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2020-10-24T16:23:56+0100" data-time="1603553036" data-date-string="Oct 24, 2020" data-time-string="4:23 PM" title="Oct 24, 2020 at 4:23 PM">Oct 24, 2020</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>3</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>211</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/field-to-count-specific-records.1806723/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2020-10-26T09:50:42+0000" data-time="1603705842" data-date-string="Oct 26, 2020" data-time-string="9:50 AM" title="Oct 26, 2020 at 9:50 AM">Oct 26, 2020</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1801324" data-author="v5652"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/v5652.1358232/" class="avatar avatar--s" data-user-id="1358232" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="v5652" class="avatar-u1358232-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/trouble-opening-database-make-sure-the-drive-is-available.1801324/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/trouble-opening-database-make-sure-the-drive-is-available.1801324/preview">Trouble opening database Make sure the drive is available </a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/v5652.1358232/" class="username " dir="auto" data-user-id="1358232" data-xf-init="member-tooltip">v5652</a></li> <li class="structItem-startDate"><a href="/threads/trouble-opening-database-make-sure-the-drive-is-available.1801324/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2020-02-29T10:02:19+0000" data-time="1582970539" data-date-string="Feb 29, 2020" data-time-string="10:02 AM" title="Feb 29, 2020 at 10:02 AM">Feb 29, 2020</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>270</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/trouble-opening-database-make-sure-the-drive-is-available.1801324/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2020-03-04T06:00:42+0000" data-time="1583301642" data-date-string="Mar 4, 2020" data-time-string="6:00 AM" title="Mar 4, 2020 at 6:00 AM">Mar 4, 2020</time></a> <div class="structItem-minor"> <a href="/members/v5652.1358232/" class="username " dir="auto" data-user-id="1358232" data-xf-init="member-tooltip">v5652</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/v5652.1358232/" class="avatar avatar--xxs" data-user-id="1358232" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="v5652" class="avatar-u1358232-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1799157" data-author="TrekBiker"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/trekbiker.1570060/" class="avatar avatar--s" data-user-id="1570060" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="TrekBiker" class="avatar-u1570060-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/prevent-new-data-being-used-when-using-archive-backend.1799157/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/prevent-new-data-being-used-when-using-archive-backend.1799157/preview">Prevent new data being used when using Archive backend</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/trekbiker.1570060/" class="username " dir="auto" data-user-id="1570060" data-xf-init="member-tooltip">TrekBiker</a></li> <li class="structItem-startDate"><a href="/threads/prevent-new-data-being-used-when-using-archive-backend.1799157/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2020-01-07T14:39:48+0000" data-time="1578407988" data-date-string="Jan 7, 2020" data-time-string="2:39 PM" title="Jan 7, 2020 at 2:39 PM">Jan 7, 2020</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>0</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>608</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/prevent-new-data-being-used-when-using-archive-backend.1799157/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2020-01-07T14:39:48+0000" data-time="1578407988" data-date-string="Jan 7, 2020" data-time-string="2:39 PM" title="Jan 7, 2020 at 2:39 PM">Jan 7, 2020</time></a> <div class="structItem-minor"> <a href="/members/trekbiker.1570060/" class="username " dir="auto" data-user-id="1570060" data-xf-init="member-tooltip">TrekBiker</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/trekbiker.1570060/" class="avatar avatar--xxs" data-user-id="1570060" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="TrekBiker" class="avatar-u1570060-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1799089" data-author="TrekBiker"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/trekbiker.1570060/" class="avatar avatar--s" data-user-id="1570060" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="TrekBiker" class="avatar-u1570060-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/choose-backend-using-vba.1799089/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/choose-backend-using-vba.1799089/preview">Choose Backend using VBA</a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/trekbiker.1570060/" class="username " dir="auto" data-user-id="1570060" data-xf-init="member-tooltip">TrekBiker</a></li> <li class="structItem-startDate"><a href="/threads/choose-backend-using-vba.1799089/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2020-01-03T12:40:01+0000" data-time="1578055201" data-date-string="Jan 3, 2020" data-time-string="12:40 PM" title="Jan 3, 2020 at 12:40 PM">Jan 3, 2020</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>4</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>315</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/choose-backend-using-vba.1799089/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2020-01-07T14:38:21+0000" data-time="1578407901" data-date-string="Jan 7, 2020" data-time-string="2:38 PM" title="Jan 7, 2020 at 2:38 PM">Jan 7, 2020</time></a> <div class="structItem-minor"> <a href="/members/andrzejek.1105365/" class="username " dir="auto" data-user-id="1105365" data-xf-init="member-tooltip">Andrzejek</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/andrzejek.1105365/" class="avatar avatar--xxs" data-user-id="1105365" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="Andrzejek" class="avatar-u1105365-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1796808" data-author="Lidias13"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/lidias13.1689048/" class="avatar avatar--s" data-user-id="1689048" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="Lidias13" class="avatar-u1689048-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/odata-contains-fields-from-multiple-tables-in-single-table-with-different-field-names-for-same.1796808/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/odata-contains-fields-from-multiple-tables-in-single-table-with-different-field-names-for-same.1796808/preview">Odata contains fields from multiple tables in single table with different field names - for same</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/lidias13.1689048/" class="username " dir="auto" data-user-id="1689048" data-xf-init="member-tooltip">Lidias13</a></li> <li class="structItem-startDate"><a href="/threads/odata-contains-fields-from-multiple-tables-in-single-table-with-different-field-names-for-same.1796808/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-09-05T20:52:03+0100" data-time="1567713123" data-date-string="Sep 5, 2019" data-time-string="8:52 PM" title="Sep 5, 2019 at 8:52 PM">Sep 5, 2019</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>1</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>201</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/odata-contains-fields-from-multiple-tables-in-single-table-with-different-field-names-for-same.1796808/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-09-06T14:06:58+0100" data-time="1567775218" data-date-string="Sep 6, 2019" data-time-string="2:06 PM" title="Sep 6, 2019 at 2:06 PM">Sep 6, 2019</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1796260" data-author="BugZap13"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/bugzap13.1653487/" class="avatar avatar--s" data-user-id="1653487" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="BugZap13" class="avatar-u1653487-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/preview">How to extract Access table schema with decimal places on numeric fields?</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/bugzap13.1653487/" class="username " dir="auto" data-user-id="1653487" data-xf-init="member-tooltip">BugZap13</a></li> <li class="structItem-startDate"><a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-08-05T10:00:43+0100" data-time="1564995643" data-date-string="Aug 5, 2019" data-time-string="10:00 AM" title="Aug 5, 2019 at 10:00 AM">Aug 5, 2019</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>688</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/how-to-extract-access-table-schema-with-decimal-places-on-numeric-fields.1796260/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-08-05T12:04:40+0100" data-time="1565003080" data-date-string="Aug 5, 2019" data-time-string="12:04 PM" title="Aug 5, 2019 at 12:04 PM">Aug 5, 2019</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1795239" data-author="puforee"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/puforee.1194207/" class="avatar avatar--s" data-user-id="1194207" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="puforee" class="avatar-u1194207-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/best-way-to-setup-tables-for-multible-related-data-sets.1795239/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/best-way-to-setup-tables-for-multible-related-data-sets.1795239/preview">Best way to setup tables for multible related data sets</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/puforee.1194207/" class="username " dir="auto" data-user-id="1194207" data-xf-init="member-tooltip">puforee</a></li> <li class="structItem-startDate"><a href="/threads/best-way-to-setup-tables-for-multible-related-data-sets.1795239/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-06-10T16:54:18+0100" data-time="1560182058" data-date-string="Jun 10, 2019" data-time-string="4:54 PM" title="Jun 10, 2019 at 4:54 PM">Jun 10, 2019</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>1</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>197</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/best-way-to-setup-tables-for-multible-related-data-sets.1795239/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-06-10T17:49:29+0100" data-time="1560185369" data-date-string="Jun 10, 2019" data-time-string="5:49 PM" title="Jun 10, 2019 at 5:49 PM">Jun 10, 2019</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1794175" data-author="jjMedrano"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/jjmedrano.1687429/" class="avatar avatar--s" data-user-id="1687429" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="jjMedrano" class="avatar-u1687429-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/union-all-with-attachment-data-type.1794175/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/union-all-with-attachment-data-type.1794175/preview">UNION ALL with Attachment data type</a> <span class="votesInfo" data-xf-init="tooltip" title="1 member likes this thread!" >1</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/jjmedrano.1687429/" class="username " dir="auto" data-user-id="1687429" data-xf-init="member-tooltip">jjMedrano</a></li> <li class="structItem-startDate"><a href="/threads/union-all-with-attachment-data-type.1794175/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2019-04-16T16:20:09+0100" data-time="1555428009" data-date-string="Apr 16, 2019" data-time-string="4:20 PM" title="Apr 16, 2019 at 4:20 PM">Apr 16, 2019</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>8</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>247</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/union-all-with-attachment-data-type.1794175/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2019-04-17T13:52:27+0100" data-time="1555505547" data-date-string="Apr 17, 2019" data-time-string="1:52 PM" title="Apr 17, 2019 at 1:52 PM">Apr 17, 2019</time></a> <div class="structItem-minor"> <a href="/members/andrzejek.1105365/" class="username " dir="auto" data-user-id="1105365" data-xf-init="member-tooltip">Andrzejek</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/andrzejek.1105365/" class="avatar avatar--xxs" data-user-id="1105365" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="Andrzejek" class="avatar-u1105365-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1788750" data-author="oxicottin"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/oxicottin.1383069/" class="avatar avatar--s" data-user-id="1383069" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="oxicottin" class="avatar-u1383069-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/creating-tables-and-relationships-for-new-database.1788750/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/creating-tables-and-relationships-for-new-database.1788750/preview">Creating tables and relationships for new database</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/oxicottin.1383069/" class="username " dir="auto" data-user-id="1383069" data-xf-init="member-tooltip">oxicottin</a></li> <li class="structItem-startDate"><a href="/threads/creating-tables-and-relationships-for-new-database.1788750/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2018-08-10T08:24:02+0100" data-time="1533885842" data-date-string="Aug 10, 2018" data-time-string="8:24 AM" title="Aug 10, 2018 at 8:24 AM">Aug 10, 2018</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>678</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/creating-tables-and-relationships-for-new-database.1788750/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2018-08-10T20:43:32+0100" data-time="1533930212" data-date-string="Aug 10, 2018" data-time-string="8:43 PM" title="Aug 10, 2018 at 8:43 PM">Aug 10, 2018</time></a> <div class="structItem-minor"> <a href="/members/majp.1053895/" class="username " dir="auto" data-user-id="1053895" data-xf-init="member-tooltip">MajP</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/majp.1053895/" class="avatar avatar--xxs" data-user-id="1053895" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="MajP" class="avatar-u1053895-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1786896" data-author="OCM"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/ocm.299564/" class="avatar avatar--s" data-user-id="299564" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="OCM" class="avatar-u299564-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/append-import.1786896/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/append-import.1786896/preview">append/import</a> <span class="votesInfo" data-xf-init="tooltip" title="2 members like this thread!" >2</span> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/ocm.299564/" class="username " dir="auto" data-user-id="299564" data-xf-init="member-tooltip">OCM</a></li> <li class="structItem-startDate"><a href="/threads/append-import.1786896/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2018-05-14T22:50:25+0100" data-time="1526334625" data-date-string="May 14, 2018" data-time-string="10:50 PM" title="May 14, 2018 at 10:50 PM">May 14, 2018</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>11</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>307</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/append-import.1786896/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2018-05-15T16:30:27+0100" data-time="1526398227" data-date-string="May 15, 2018" data-time-string="4:30 PM" title="May 15, 2018 at 4:30 PM">May 15, 2018</time></a> <div class="structItem-minor"> <a href="/members/ocm.299564/" class="username " dir="auto" data-user-id="299564" data-xf-init="member-tooltip">OCM</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/ocm.299564/" class="avatar avatar--xxs" data-user-id="299564" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" alt="OCM" class="avatar-u299564-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> <div class="structItem structItem--thread js-inlineModContainer js-threadListItem-1786807" data-author="cp950"> <div class="structItem-cell structItem-cell--icon"> <div class="structItem-iconContainer"> <a href="/members/cp950.50482/" class="avatar avatar--s" data-user-id="50482" data-xf-init="member-tooltip"> <img src="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=48" srcset="https://secure.gravatar.com/avatar/d41d8cd98f00b204e9800998ecf8427e?s=96 2x" alt="cp950" class="avatar-u50482-s" width="48" height="48" loading="lazy" /> </a> </div> </div> <div class="structItem-cell structItem-cell--main" data-xf-init="touch-proxy"> <ul class="structItem-statuses"> <li> <i class="structItem-status structItem-status--locked" aria-hidden="true" title="Locked"></i> <span class="u-srOnly">Locked</span> </li> <li> <i class="fa--xf fal fa-question-circle structItem-status" aria-hidden="true" title="Question"></i> <span class="u-srOnly">Question</span> </li> </ul> <div class="structItem-title"> <a href="/threads/how-to-show-nulls-in-table-view.1786807/" class="" data-tp-primary="on" data-xf-init="preview-tooltip" data-preview-url="/threads/how-to-show-nulls-in-table-view.1786807/preview">HOW TO : Show NULLs in Table View</a> </div> <div class="structItem-minor"> <ul class="structItem-parts"> <li><a href="/members/cp950.50482/" class="username " dir="auto" data-user-id="50482" data-xf-init="member-tooltip">cp950</a></li> <li class="structItem-startDate"><a href="/threads/how-to-show-nulls-in-table-view.1786807/" rel="nofollow"><time class="u-dt" dir="auto" datetime="2018-05-10T10:07:38+0100" data-time="1525943258" data-date-string="May 10, 2018" data-time-string="10:07 AM" title="May 10, 2018 at 10:07 AM">May 10, 2018</time></a></li> </ul> </div> </div> <div class="structItem-cell structItem-cell--meta" title="First message reaction score: 0"> <dl class="pairs pairs--justified"> <dt>Replies</dt> <dd>2</dd> </dl> <dl class="pairs pairs--justified structItem-minor"> <dt>Views</dt> <dd>195</dd> </dl> </div> <div class="structItem-cell structItem-cell--latest"> <a href="/threads/how-to-show-nulls-in-table-view.1786807/latest" rel="nofollow"><time class="structItem-latestDate u-dt" dir="auto" datetime="2018-05-10T11:22:37+0100" data-time="1525947757" data-date-string="May 10, 2018" data-time-string="11:22 AM" title="May 10, 2018 at 11:22 AM">May 10, 2018</time></a> <div class="structItem-minor"> <a href="/members/dhookom.529593/" class="username " dir="auto" data-user-id="529593" data-xf-init="member-tooltip">dhookom</a> </div> </div> <div class="structItem-cell structItem-cell--icon structItem-cell--iconEnd"> <div class="structItem-iconContainer"> <a href="/members/dhookom.529593/" class="avatar avatar--xxs" data-user-id="529593" data-xf-init="member-tooltip"> <img src="/data/avatars/s/529/529593.jpg?1723729896" alt="dhookom" class="avatar-u529593-s" width="48" height="48" loading="lazy" /> </a> </div> </div> </div> </div> </div> </div> </div> <div class="block-outer block-outer--after"> <div class="block-outer-main"><nav class="pageNavWrapper pageNavWrapper--full "> <div class="pageNav pageNav--skipEnd"> <ul class="pageNav-main"> <li class="pageNav-page pageNav-page--current "><a href="/forums/microsoft-access-tables-and-relationships.700/">1</a></li> <li class="pageNav-page pageNav-page--later"><a href="/forums/microsoft-access-tables-and-relationships.700/page-2">2</a></li> <li class="pageNav-page pageNav-page--later"><a href="/forums/microsoft-access-tables-and-relationships.700/page-3">3</a></li> <li class="pageNav-page pageNav-page--skip pageNav-page--skipEnd"> <a data-xf-init="tooltip" title="Go to page" data-xf-click="menu" role="button" tabindex="0" aria-expanded="false" aria-haspopup="true">…</a> <div class="menu menu--pageJump" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <h4 class="menu-header">Go to page</h4> <div class="menu-row" data-xf-init="page-jump" data-page-url="/forums/microsoft-access-tables-and-relationships.700/page-%page%"> <div class="inputGroup inputGroup--numbers"> <div class="inputGroup inputGroup--numbers inputNumber" data-xf-init="number-box"><input type="number" pattern="\d*" class="input input--number js-numberBoxTextInput input input--numberNarrow js-pageJumpPage" value="4" min="1" max="302" step="1" required="required" data-menu-autofocus="true" /></div> <span class="inputGroup-text"><button type="button" class="js-pageJumpGo button"><span class="button-text">Go</span></button></span> </div> </div> </div> </div> </li> <li class="pageNav-page "><a href="/forums/microsoft-access-tables-and-relationships.700/page-302">302</a></li> </ul> <a href="/forums/microsoft-access-tables-and-relationships.700/page-2" class="pageNav-jump pageNav-jump--next">Next</a> </div> <div class="pageNavSimple"> <a class="pageNavSimple-el pageNavSimple-el--current" data-xf-init="tooltip" title="Go to page" data-xf-click="menu" role="button" tabindex="0" aria-expanded="false" aria-haspopup="true"> 1 of 302 </a> <div class="menu menu--pageJump" data-menu="menu" aria-hidden="true"> <div class="menu-content"> <h4 class="menu-header">Go to page</h4> <div class="menu-row" data-xf-init="page-jump" data-page-url="/forums/microsoft-access-tables-and-relationships.700/page-%page%"> <div class="inputGroup inputGroup--numbers"> <div class="inputGroup inputGroup--numbers inputNumber" data-xf-init="number-box"><input type="number" pattern="\d*" class="input input--number js-numberBoxTextInput input input--numberNarrow js-pageJumpPage" value="1" min="1" max="302" step="1" required="required" data-menu-autofocus="true" /></div> <span class="inputGroup-text"><button type="button" class="js-pageJumpGo button"><span class="button-text">Go</span></button></span> </div> </div> </div> </div> <a href="/forums/microsoft-access-tables-and-relationships.700/page-2" class="pageNavSimple-el pageNavSimple-el--next"> Next <i aria-hidden="true"></i> </a> <a href="/forums/microsoft-access-tables-and-relationships.700/page-302" class="pageNavSimple-el pageNavSimple-el--last" data-xf-init="tooltip" title="Last"> <i aria-hidden="true"></i> <span class="u-srOnly">Last</span> </a> </div> </nav> </div> <div class="block-outer-opposite"> <a href="/login/" class="button--link button--wrap button" data-xf-click="overlay"><span class="button-text"> You must log in or register to post here. </span></a> </div> </div> </div> </div> </div> <div class="p-sidebarWrapper"> <div class="p-body-sidebar"> <div class="block block--login"> <form action="/login/login" method="post" class="" > <input type="hidden" name="_xfToken" value="1732697272,a54730b8ba846e256320b0017b115787" /> <div class="block-container"> <h3 class="block-minorHeader"> Log in </h3> <div class="block-body"> <div class="block-row"> <dl class="formRow formRow--input"> <dt> <div class="formRow-labelWrapper"> <label class="formRow-label" for="_xfUid-1-1732697272">Your name or email address</label></div> </dt> <dd> <input type="text" class="input" name="login" autocomplete="username" id="_xfUid-1-1732697272" /> </dd> </dl> <dl class="formRow formRow--input"> <dt> <div class="formRow-labelWrapper"> <label class="formRow-label" for="_xfUid-2-1732697272">Password</label></div> </dt> <dd> <input type="password" class="input" name="password" autocomplete="current-password" id="_xfUid-2-1732697272" /> <a href="/lost-password/" data-xf-click="overlay">Forgot your password?</a> </dd> </dl> <dl class="formRow"> <dt> <div class="formRow-labelWrapper"></div> </dt> <dd> <ul class="inputChoices"> <li class="inputChoices-choice"><label class="iconic"><input type="checkbox" name="remember" value="1" checked="checked" /><i aria-hidden="true"></i><span class="iconic-label">Stay logged in</span></label></li> </ul> </dd> </dl> <dl class="formRow formSubmitRow"> <dt></dt> <dd> <div class="formSubmitRow-main"> <div class="formSubmitRow-bar"></div> <div class="formSubmitRow-controls"><button type="submit" class="button--primary button button--icon button--icon--login"><span class="button-text">Log in</span></button></div> </div> </dd> </dl> <dl class="formRow formRegisterRow"> <dt></dt> <dd>Don't have an account? <a href="/register/" data-xf-click="overlay" data-follow-redirects="on">Register now</a></dd> </dl> </div> </div> </div> </form> </div> <div class="block"> <div class="block-container" data-widget-id="18" data-widget-key="right_search_top" data-widget-definition="html"> <h3 class="block-minorHeader">Part and Inventory Search</h3> <div class="block-body block-row"> <center><div id='div-gpt-tektips_customsearchbox'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_customsearchbox'); }); </script> </div> </center> </div> </div> </div> <div class="block"> <div class="block-container" data-widget-id="13" data-widget-key="right_rail_middle_bottom_ga" data-widget-definition="html"> <h3 class="block-minorHeader">Sponsor</h3> <div class="block-body block-row"> <center> <div id='div-gpt-tektips_sidebar1'> <script> googletag.cmd.push(function() { googletag.display('div-gpt-tektips_sidebar1'); }); </script> </div> </center> </div> </div> </div> </div> </div> </div> <div class="p-breadcrumbs--parent p-breadcrumbs--bottom"> <ul class="p-breadcrumbs p-breadcrumbs--bottom" itemscope itemtype="https://schema.org/BreadcrumbList"> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="https://www.tek-tips.com" itemprop="item"> <span itemprop="name">Home</span> </a> <meta itemprop="position" content="1" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/" itemprop="item"> <span itemprop="name">Forums</span> </a> <meta itemprop="position" content="2" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/#software.1001" itemprop="item"> <span itemprop="name">Software</span> </a> <meta itemprop="position" content="3" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/programmers.1004/" itemprop="item"> <span itemprop="name">Programmers</span> </a> <meta itemprop="position" content="4" /> </li> <li itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem"> <a href="/categories/dbms-packages.10027/" itemprop="item"> <span itemprop="name">DBMS Packages</span> </a> <meta itemprop="position" content="5" /> </li> </ul> </div> </div> </div> </div>  <footer class="p-footer" id="footer"> <div class="p-footer--container footer-stretched"> <div class="p-footer-default"> <div class="p-footer-inner"> <div class="p-footer-row"> <div class="p-footer-row-main"> <ul class="p-footer-linkList"> <li class="p-linkList-changeStyle"><a href="/misc/style" data-xf-click="overlay" data-xf-init="tooltip" title="Style: TekTips" rel="nofollow"> Style chooser </a></li> <li class="p-linkList-changeWidth"><a class="pageWidthToggle xb-toggle-default" role="button" tabindex="0" data-xf-click="toggle" data-target="html" data-active-class="xb-toggle-default" data-xf-init="toggle-storage" data-storage-type="cookie" data-storage-expiry="31556926" data-storage-key="_xb-width"> Change width </a></li> </ul> </div> <div class="p-footer-row-opposite"> <ul class="p-footer-linkList"> <li><a href="/misc/contact" data-xf-click="overlay">Contact us</a></li> <li><a href="/help/terms/">Terms and rules</a></li> <li><a href="/help/privacy-policy/">Privacy policy</a></li> <li><a href="/help/">Help</a></li> <li><a href="https://www.tek-tips.com">Home</a></li> <li><a href="/forums/-/index.rss" target="_blank" class="p-footer-rssLink" title="RSS"><span aria-hidden="true"><i class="fa--xf fal fa-rss" aria-hidden="true"></i><span class="u-srOnly">RSS</span></span></a></li> </ul> </div> </div> </div> </div> <div class="p-footer-copyright"> <div class="p-footer-inner"> <div class="p-footer-copyright--flex"> <div class="copyright-left"> Copyright © <script type="text/javascript">d = new Date();y = d.getFullYear();document.write(y);</script> WTWH Media, LLC. All Rights Reserved. </div> </div> </div> </div> </div> </footer> </div>  </div>  <div class="u-bottomFixer js-bottomFixTarget"> <ul class="notices notices--bottom_fixer js-notices" data-xf-init="notices" data-type="bottom_fixer" data-scroll-interval="6"> <li class="notice js-notice notice--primary notice--cookie" data-notice-id="-1" data-delay-duration="0" data-display-duration="0" data-auto-dismiss="0" data-visibility=""> <div class="notice-content"> <div class="u-alignCenter"> This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.<br /> By continuing to use this site, you are consenting to our use of cookies. </div> <div class="u-inputSpacer u-alignCenter"> <a href="/account/dismiss-notice" class="js-noticeDismiss button--notice button button--icon button--icon--confirm"><span class="button-text">Accept</span></a> <a href="/help/cookies" class="button--notice button"><span class="button-text">Learn more…</span></a> </div> </div> </li> </ul> </div> <div class="u-navButtons js-navButtons" data-trigger-type="up"> <a href="javascript:" class="button--scroll button"><span class="button-text"><i class="fa--xf fal fa-arrow-left" aria-hidden="true"></i><span class="u-srOnly">Back</span></span></a> </div> <div class="u-scrollButtons js-scrollButtons" data-trigger-type="up"> <a href="#top" class="button--scroll button" data-xf-click="scroll-to"><span class="button-text"><i class="fa--xf fal fa-arrow-up" aria-hidden="true"></i><span class="u-srOnly">Top</span></span></a> </div> <script src="/js/vendor/jquery/jquery-3.5.1.min.js?_v=e65b7ca0"></script> <script src="/js/vendor/vendor-compiled.js?_v=e65b7ca0"></script> <script src="/js/xf/core-compiled.js?_v=e65b7ca0"></script> <script src="/js/sv/ese/xf/structure.min.js?_v=e65b7ca0"></script> <script src="/js/xf/notice.min.js?_v=e65b7ca0"></script> <script> $(".xb-searchWrapper").on("click", function(event) { $(".xb-searchWrapper").addClass("is-active"); event.stopPropagation(); }); $(".xb-searchWrapper").on("click", function(event) { event.stopPropagation(); }); $(document).on("click", function(event) { $(".xb-searchWrapper").removeClass("is-active"); }); </script> <script> jQuery.extend(true, XF.config, { // userId: 0, enablePush: false, pushAppServerKey: '', url: { fullBase: 'https://www.tek-tips.com/', basePath: '/', css: '/css.php?css=__SENTINEL__&s=3&l=1&d=1731063743', keepAlive: '/login/keep-alive' }, cookie: { path: '/', domain: '', prefix: 'xf_', secure: true, consentMode: 'simple', consented: ["optional","_third_party"] }, cacheKey: 'cf136c583e6591f869f990ac86545fee', csrf: '1732697272,a54730b8ba846e256320b0017b115787', js: {"\/js\/sv\/ese\/xf\/structure.min.js?_v=e65b7ca0":true,"\/js\/xf\/notice.min.js?_v=e65b7ca0":true}, css: {"public:notices.less":true,"public:structured_list.less":true,"public:svESE_autocomplete.less":true,"public:xb.less":true,"public:xb_search.less":true,"public:xb_sidebar_login.less":true,"public:xb_welcome.less":true,"public:xc_votes_button.less":true,"public:extra.less":true}, time: { now: 1732697272, today: 1732665600, todayDow: 3, tomorrow: 1732752000, yesterday: 1732579200, week: 1732147200 }, borderSizeFeature: '2px', fontAwesomeWeight: 'l', enableRtnProtect: true, enableFormSubmitSticky: true, uploadMaxFilesize: 268435456, allowedVideoExtensions: ["m4v","mov","mp4","mp4v","mpeg","mpg","ogv","webm"], allowedAudioExtensions: ["mp3","opus","ogg","wav"], shortcodeToEmoji: true, visitorCounts: { conversations_unread: '0', alerts_unviewed: '0', total_unread: '0', title_count: true, icon_indicator: true }, jsState: {}, publicMetadataLogoUrl: '', publicPushBadgeUrl: 'https://www.tek-tips.com/styles/default/xenforo/bell.png' }); jQuery.extend(XF.phrases, { // date_x_at_time_y: "{date} at {time}", day_x_at_time_y: "{day} at {time}", yesterday_at_x: "Yesterday at {time}", x_minutes_ago: "{minutes} minutes ago", one_minute_ago: "1 minute ago", a_moment_ago: "A moment ago", today_at_x: "Today at {time}", in_a_moment: "In a moment", in_a_minute: "In a minute", in_x_minutes: "In {minutes} minutes", later_today_at_x: "Later today at {time}", tomorrow_at_x: "Tomorrow at {time}", day0: "Sunday", day1: "Monday", day2: "Tuesday", day3: "Wednesday", day4: "Thursday", day5: "Friday", day6: "Saturday", dayShort0: "Sun", dayShort1: "Mon", dayShort2: "Tue", dayShort3: "Wed", dayShort4: "Thu", dayShort5: "Fri", dayShort6: "Sat", month0: "January", month1: "February", month2: "March", month3: "April", month4: "May", month5: "June", month6: "July", month7: "August", month8: "September", month9: "October", month10: "November", month11: "December", active_user_changed_reload_page: "The active user has changed. Reload the page for the latest version.", server_did_not_respond_in_time_try_again: "The server did not respond in time. Please try again.", oops_we_ran_into_some_problems: "Oops! We ran into some problems.", oops_we_ran_into_some_problems_more_details_console: "Oops! We ran into some problems. Please try again later. More error details may be in the browser console.", file_too_large_to_upload: "The file is too large to be uploaded.", uploaded_file_is_too_large_for_server_to_process: "The uploaded file is too large for the server to process.", files_being_uploaded_are_you_sure: "Files are still being uploaded. Are you sure you want to submit this form?", attach: "Attach files", rich_text_box: "Rich text box", close: "Close", link_copied_to_clipboard: "Link copied to clipboard.", text_copied_to_clipboard: "Text copied to clipboard.", loading: "Loading…", you_have_exceeded_maximum_number_of_selectable_items: "You have exceeded the maximum number of selectable items.", processing: "Processing", 'processing...': "Processing…", showing_x_of_y_items: "Showing {count} of {total} items", showing_all_items: "Showing all items", no_items_to_display: "No items to display", number_button_up: "Increase", number_button_down: "Decrease", push_enable_notification_title: "Push notifications enabled successfully at Tek-Tips", push_enable_notification_body: "Thank you for enabling push notifications!", pull_down_to_refresh: "Pull down to refresh", release_to_refresh: "Release to refresh", refreshing: "Refreshing…" , "svStandardLib_time.day": "{count} day", "svStandardLib_time.days": "{count} days", "svStandardLib_time.hour": "{count} hour", "svStandardLib_time.hours": "{count} hours", "svStandardLib_time.minute": "{count} minutes", "svStandardLib_time.minutes": "{count} minutes", "svStandardLib_time.month": "{count} month", "svStandardLib_time.months": "{count} months", "svStandardLib_time.second": "{count} second", "svStandardLib_time.seconds": "{count} seconds", "svStandardLib_time.week": "time.week", "svStandardLib_time.weeks": "{count} weeks", "svStandardLib_time.year": "{count} year", "svStandardLib_time.years": "{count} years" }); </script> <form style="display:none" hidden="hidden"> <input type="text" name="_xfClientLoadTime" value="" id="_xfClientLoadTime" title="_xfClientLoadTime" tabindex="-1" /> </form>  </body> </html>

CINXE.COM

Microsoft: Access Tables and Relationships | Tek-Tips